Hi,
I receive an automatic dump of data on a weekly basis that looks like the below Table A. Basically, the first column is by category and the remaining columns are by week. How would I summarize the hours (found within the text) into Table B, which would summarize it by category (A,B,C) and Type (Submitted, Approval, Invoice, etc)? Any help would be highly appreciated.
Table A: Table B:
<colgroup><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I receive an automatic dump of data on a weekly basis that looks like the below Table A. Basically, the first column is by category and the remaining columns are by week. How would I summarize the hours (found within the text) into Table B, which would summarize it by category (A,B,C) and Type (Submitted, Approval, Invoice, etc)? Any help would be highly appreciated.
Table A: Table B:
Category | 08-Jun-18 | 15-Jun-18 | Submitted | Approval | Invoice | Client | Document | ||
A | Invoice (HRS : 383 | Invoice (HRS : 147.5 | A | ||||||
A | Document (HRS : 36 | Document (HRS : 39 | B | ||||||
B | Submitted (HRS : 53 | Submitted (HRS : 41 | C | ||||||
C | Submitted (HRS : 9 | Submitted (HRS : 6.5 | |||||||
C | Submitted (HRS : 5 | Client (HRS : 54 | |||||||
C | Submitted (HRS : 19 | Submitted (HRS : 18 | |||||||
C | Submitted (HRS : 3 | Submitted (HRS : 2 | |||||||
C | Submitted (HRS : 2 | Submitted (HRS : 7 | |||||||
A | Invoice (HRS : 778.5 | Invoice (HRS : 446.5 | |||||||
A | Invoice (HRS : 747 | Invoice (HRS : 842 | |||||||
A | Invoice (HRS : 936.5 | Approval (HRS : 8 | |||||||
A | Invoice (HRS : 982.5 | Invoice (HRS : 819.5 | |||||||
A | Invoice (HRS : 918 | Invoice (HRS : 1122 | |||||||
A | Invoice (HRS : 58.5 | Invoice (HRS : 292 | |||||||
A | Client (HRS : 528.5 | Client (HRS : 429.5 | |||||||
B | Approval (HRS : 4 | Approval (HRS : 8 |
<colgroup><col><col span="2"><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>