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

user_5632629 · Answer

use:

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