CODEWITHSUNDEEP
arraysgoogle-sheetstransposegoogle-query-languagetextjoin
SanLot
SanLot

Reputation: 65

Combine specific columns into one column in Google sheets

I am trying to transpose the data in the table so that Conversion Types are all stacked in one column with corresponding values. Please see the example in this sheet: https://docs.google.com/spreadsheets/d/1OlQGGHnLiZFdSjbRS_2Fw7_Vhj8Z1WNZLpcZ6EWJPUA/edit?usp=sharing enter image description here

Upvotes: 3

Views: 148

Answers (1)

player0
player0

Reputation: 1

use:

=INDEX(SPLIT(QUERY(FLATTEN(IF(D2:F="",, A2:A&"×"&B2:B&"×"&C2:C&"×"&D1:F1&"×"&D2:F)), 
 "where Col1 is not null", 0), "×"))

enter image description here

Upvotes: 2

Related Questions