Transpose data from a excel template in a line wise

[itsmesunilb]

Hi,

I have data in a table form in excel template which I want to capture line wise so that I can do further analysis on the data.
I would like to generate a simple template which could help me with all the details in a tablular form so that I can use this info for further analysis.

In the attached file, there is a sheet titled "Input" which has the details of the Managers visiting their partners in a particular state. There are about 30 such states with around 350 managers reporting on daily basis.

Required data sample is given in the "summary" tab in the attached sheet. Look forward to your help on the concern at earliest.
Thanks