I am unsure if this is the appropriate place or title for what I'm needing. Mods please let me know if I need to move or re-title this, I'm a bit over my head on this one. Please see attached example.
What I am wanting to accomplish is to take the data from the first sheet and obtain the results from the second. Names are listed in col A and they are qualified for various shifts denoted by an 'x' in the column associated with the shift. What I need is to have the name copied to a second row and the corresponding shift(s) in another column. Unfortunately, I cannot use a comma separated list so each entry needs to be on a separate row.
If this is not possible and you have another format for the base data I am happy to hear suggestions.
Thank you in advance!
Bookmarks