Hello,
I have a spreadsheet set as such,

Columns
A = Date
B = Employee (B2 THRU B116 , Column to house formula)
Columns C1 thru z1 have employee names
in C1 thru Z1 I have a 1 indicatiing they are assigned this day.

I would like the formula to review C1:Z1 and if there is a 1 in a column
bring back the employees name to that row in column B and combine them
together.

I hope this is clear, I need to stay away from a pivot table though, any
help would be great.

Thank you,
Lou