Good day! Any assistance will be much appreciated
I've received a few giant data lists from SARS. Unfortunately, it looks something like this:
in column A, the folowing list repeats itself about 100 times:
Tax Reference
PRN Number
Date
Capital
Interest
Penalties
Additional Tax Amount
Total

In Column B, there are different values each time for each of the labels in column A
Is there any way I can change all the repetitive data in column A into a single header row, with Column B data listed underneath in rows that can be calculated?
I've tried with a pivot table, but it is not working out for me.
Thank you in advance!