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!!
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!!