For accounting purposes, household expenses are recorded in the following columns:
- Date
- Description
- Sum Paid
- Category
I would like to be able to have another table on the side, where all the entries are restructured in the following table:
CATEGORY-A TOTAL SUM PAID FOR CATEGORY-A ITEMS Date Item A1 Description Item A1 Sum Paid Item A1 Date Item A2 Description Item A2 Sum Paid Item A2 (blank row) (blank row) (blank row) CATEGORY-B TOTAL SUM PAID FOR CATEGORY-B ITEMS Date Item B1 Description Item B1 Sum Paid Item B1 Date Item B2 Description Item B2 Sum Paid Item B2 (blank row) (blank row) (blank row) CATEGORY-C TOTAL SUM PAID FOR CATEGORY-C ITEMS Date Item C1 Description Item C1 Sum Paid Item C1 Date Item C2 Description Item C2 Sum Paid Item C2 (blank row) (blank row) (blank row)
Could you help me with the correct way to go about it?
Bookmarks