Formula problem and a pivot does not help...please can you?

[dollyann]

Hi

I have an excel query and i can not figure it out:

I have a list of names in column A and Dates along in Row 1. And under the dates by the names are zeros or BH (Bank Holiday), W (worked), H (Hol) & HF (Half Day Hol)

I am trying to get results by looking at the name i want to know when they have holiday (H) or half day holiday (HF)and to give me the date

For Example:

My Table look like:

01/01/19 02/01/2019 03/01/2019 04/01/2019
Tony H W 0 H
John 0 0 0 HF
Sarah 0 0 HF 0
David H H H H
Steve 0 0 0 0

And i would like my results to look like:

Tony 01/01/19, 04/01/2019
John 04/01/19
Sarah 03/01/19
David 01/01/19,02/01/19, 03/01/19, 04/01/19
Steve

I have tried pivot table and just can't get it to work Does anybody have any ideas to help me

Really appriecate any help.... Please!!

 

[sandy666]

You're welcome