Consolidating rows

[marcidee]

I have a sheet that has a blank line after every weekending - each section will have several rows that I need to consolidate by person with totals in each column - so in the example below I would need 1 line for Annette for 3/4/16 with a total for each of the last 4 columns and so on for each name on the 3/4/16 (column B) - then this would be repeated for the next week 10/4/16 and so on for the whole year.

Can you help me with a script for this?

Annette	03/04/2016	01 Apr 2016	RGN-G5 - Day	7.50	7.50	17.25	129.375
Annette	03/04/2016	02 Apr 2016	RGN-G5 - Sat Day	7.50	7.50	22.43	168.225
Annette	03/04/2016	03 Apr 2016	RGN-G5 - Sun Day	7.50	7.50	27.60	207
Josh	03/04/2016	29 Mar 2016	HCA - Day	8.00	8.00	6.70	53.6
Josh	03/04/2016	28 Mar 2016	HCA - Bank Hol Day	7.00	7.00	8.50	59.5
Tomasz	03/04/2016	30 Mar 2016	SW - Day	14.50	14.50	7.00	101.5
Tomasz	03/04/2016	28 Mar 2016	SW - Bank Hol Day	13.50	13.50	8.00	108
Tomasz	03/04/2016	03 Apr 2016	SW - Sun Day	6.85	6.85	7.25	49.6625
Annette	10/04/2016	05 Apr 2016	RGN-G5 - Day	7.50	7.50	17.25	129.375
Josh	10/04/2016	09 Apr 2016	SW - Day	5.00	5.00	7.50	37.5
Josh	10/04/2016	09 Apr 2016	SW - Day	11.00	11.00	7.50	82.5
Josh	10/04/2016	06 Apr 2016	SW - Day	8.00	8.00	7.20	57.6
Tomasz	10/04/2016	04 Apr 2016	SW - Day	14.50	14.50	7.20	104.4
Tomasz	10/04/2016	05 Apr 2016	SW - Day	7.50	7.50	7.20	54
Tomasz	10/04/2016	08 Apr 2016	SW - Day	7.50	7.50	7.20	54
Tomasz	10/04/2016	09 Apr 2016	SW - Sat Day	7.50	7.50	7.25	54.375
Tomasz	10/04/2016	08 Apr 2016	SW - Day	7.00	7.00	7.20	50.4

<tbody>
</tbody>

 

[lhartono]

You can use Pivot Table.

 

[marcidee]

You can use Pivot Table.

Thank you for your response - I am hoping for a script so I can automate the process