How to create lists from intersecting column and row headers?

Marcus Coates

New member
Joined
Sep 11, 2012
Messages
12
Reaction score
0
Points
0
Hi I currently have a table with column and row headers. Row headers are pupils names. Column headers are activities. If a pupil is going on a certain activity I put the letter Y in the cell. What I would like to do is create a new table which looks at a pupils name, searches along their row and when it finds a Y it will just simply give the name of the activity.

Such as

John cinema bowling paintballing
Connor paintball ice skating

Etc

Sorry I am posting this from my phone.

Any help would be great

Thanks

Marcus
 

Azumi

New member
Joined
Jan 2, 2014
Messages
30
Reaction score
0
Points
0
Location
Indonesia
Excel Version(s)
2010
You have your sample workbook? maybe we can figure it out faster with it... try to upload it at the forum

Azumi
 
Top