yogi_Rearrange (CrossTab) The Data In Another Sheet Per User Specification

Google Spreadsheet   Post  #2364

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-12-2018

question by: nannam732
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/-srSv3Ti1ns;context-place=forum/docs
Help! Formula confused

Hi everyone,

Having trouble trying to find the right formula for this problem. This data I'm trying to organize is set up in a very specific way. The user fills in a question, adds two tags, and it shows up in a file like this:

	Tags
Question	Milk Chocolate	Dark Chocolate	White Chocolate	Sea Salt	Almonds	Caramel
Question 1		✓			✓
Question 2			✓		✓
Question 3		✓		✓
Question 4	✓			✓
Question 5	✓					✓

However this makes it extremely manual to have to figure out which tags are assigned to each question. What formula do I use to go about getting this output? 

Question	Tag 1	Tag 2
Question 1	Dark Chocolate	Almonds
Question 2	White Chocolate	Almonds
Question 3	Dark Chocolate	Sea Salt
Question 4	Milk Chocolate	Sea Salt
Question 5	Milk Chocolate	Caramel

Thank you for your help!