I have a table like below where I would like to aggregate,

Account Cat1 Cat2 Cat3 Cat4 Cat5 Cat6 Cat7 Amount
1100 REG
100.00
1120 FMA
200.00
1120 FIS
400.00
1120 FMA
600.00

The problem with using the pivot table is that when the accounts are the
same it does not repeat the accounts. Is there another way of aggregating
these rows.