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!