Monday, February 12, 2018

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
QuestionMilk ChocolateDark ChocolateWhite ChocolateSea SaltAlmondsCaramel
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? 

QuestionTag 1Tag 2
Question 1Dark ChocolateAlmonds
Question 2White ChocolateAlmonds
Question 3Dark ChocolateSea Salt
Question 4Milk ChocolateSea Salt
Question 5Milk ChocolateCaramel 
Thank you for your help!