Need Help on Excel Leave Management

[winderkent]

Hi, I am trying to track my Retail Employees via Excel.

They submitted their responses via Google Form which have various Leave Types like Annual Leave, Medical Leave and etc.

Form Response 1 is their responses, but I am trying to do a LookUp Table to add on their leaves for the entire period of maybe ... 2018?

For Example Eric submitted 3 responses of Annual Leave, how do I get my Summary page to add anything that falls under Eric?

https://www.dropbox.com/s/ld84nldgu2hj7ii/Sample Leave Management.xlsx?dl=0

Appreciate if someone could really help. Thanks much in advance.

 

[winderkent]

I did a Name Manager and a Look Up Table, but I am unsure how do I add everything from "Eric".

Previously I did Row but unsure how I can get it done via Column instead.

Thanks.