Best and Easiest to filter in this format

[mahmed1]

Hi All

I have large data set that appears like this sorted

Date - Name - Code - Start - End
01/01/2018 - A - Work - 08:00 - 13:00
01/01/2018 - A - Lunch - 13:00 -13:30
01/01/2018 -A - Work - 13:30 - 16:00
01/02/2018-A - AL - 08:00 - 12:00
01/02/2018 - A- Lunch - 12:00 - 12:30
01/02/2018 - A - AL - 12:30 - 15:00
01/02/2018 - B - AL - 08:00 - 13:00
01/02/2018 - C - Work - 08:00 - 12:00
01/02/2018 - C - break - 12:00 - 12:15
01/02/2018 - C - Work - 12:15-16:00
01/03/2018 - A - Al - 08:00 - 12:00
01/03/2018 - A - Lunch - 12:00-12:30
01/03/2018 - A - Work - 12:30 - 18:00

Etc...

What im trying to do is additional columns get all the start and End times for AL and Lunch so it all appears on 1 line

Date - Name - AL start - AL end - Lunch Start - Lunch End

01/02/2018 - A - 08:00 - 15:00 - 12:00 - 12:30
01/02/2018 - B - 08:00 - 13:00 No Lunch No Lunch
01/02/2018 - C - 08:00 - 12:00 - 12:00 - 12:30

So the result to appear in 1 line like this

So essentially i just want to list All Al start and End And All Lunch start and End on 1 line..

There could be times where agents have no lunch or have AL only in the morning or afternoon etc so its a case of get how much leave they had from start to end and how much Lunch they had on that day too

What is the best way to filter or even add helper columns to achieve this result

Thank you

 

[mahmed1]

Any luck or advise please - would really appreciate it