Combine specific columns into one column in Google sheets

Question

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

player0 · Accepted Answer · 2021-08-02T22:06:18.483

2

use:

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

edited Aug 02 '21 at 22:06

answered Aug 02 '21 at 21:30

player0

thank you! Is there a way to add Conversion Type column so that we know what conversion is associated with the value? – SanLot Aug 02 '21 at 21:51
1

this is perfect! much appreciated! – SanLot Aug 02 '21 at 22:09

1 Answers1