21Aberdeen

Hi, appreciate if anyone can help on pivot table. I'm working on employee leave schedule (sample data below) and want to present it as a spreadsheet.
cheers 21 Aberdeen

EmpID Date_From Date_To Lv_type
2002516 09-Jul-16 09-Jul-16 Annual Lv
2002516 10-Jul-16 10-Jul-16 Annual Lv
2009118 12-Jul-16 12-Jul-16 Sick Lv
2002516 16-Jul-16 16-Jul-16 Sick Lv
2002516 17-Jul-16 18-Jul-16 Sick Lv
2009694 19-Jul-16 19-Jul-16 Annual Lv