I need to return names from a work roster list based on their rostered days on/off

I need to return the names of those who are rostered on and have them appear in a new table based on whether or not they are rostered to work

A B C D
1 Name Monday Tuesday wednesday
2 Bob off 4:00 4:00
3 Bill 4:00 4:00 4:00
4 Joe 4:00 off off
5 Harry off off 4:00
6 Jim 4:00 4:00 off

For example I want names returned for those that are working on Monday in the following format:

A
1 Bill
2 Joe
3 Jim

Likewise for Tuesday (separate sheet)
A
1 Bob
2 Bill
3 Jim

If anyone can help that would be much appreciated.

hi,

Upload sample workbook with enough data to explain your requirement and make sure it is not having any sensitive data

Punnam

Thanks Needforexcell. Your a legend. Worked a treat.