Monday, April 16, 2018

yogi_Rearrange Data of Events and Participants Into Table of Events By Participant

Google Spreadsheet   Post  #2427

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

question by: jpcsoccer
https://productforums.google.com/forum/#!topic/docs/SiaYzZt9CPI;context-place=forum/docs

I would like to list every row that a name appears in

 I have a spreadsheet to organize a track meet.  it goes
Event1  | name 1 | name 2
Event 2 | name 1 | name 3 | name 4
Event 3 | name 2 | name 5

I would like to produce this result
name 1 | Event 1 | Event 2
name 2 | Event 1 | Event 3
name 3 | Event 2
name 4 | Event 2
name 5 | Event 3

the sheet is attached.  would love some help!