Marcus Coates
New member
- Joined
- Sep 11, 2012
- Messages
- 12
- Reaction score
- 0
- Points
- 0
Hi I have a table with names down column A. In the next columns cells are either empty or have the letter Y. What I want to do is create a table that will look down for example column B and every time it comes to a letter Y the persons name that is the row header is listed in the new table. I have had some joy but the problem I have is for each row in the data table I have to have one in the table I'm trying to create. This means I have several rows blank then someone's name and so on