Correlate all the job numbers & hours into a list

[Angus McBagpipe]

Hello Everyone,

I have a list of Jobs and Hours worked.
I need do correlate all the job numbers into a list and add up the total hours.
Typically I have 6 columns (Job No#/Hours)with jobs across 7 rows for the days.

I have a dedicated bunch of rows below to populate the list.
Your help would be greatly appreciated.

 

[tcardwell]

How about:
Insert->Table
Insert->Pivot Table
Drag jobs to Rows Column
Drag hours to values column
Done