Transpose split data based on unique trx number

[sawan202]

Hi,

If someone could find a solution my problem, I'll be most grateful.

Problem is, I have personal expenses data stored in rows with categories in headers, and a unique trx number that tie them together, the purpose of the trx number primarily is to linked all the split data to the parent transaction. The splits can run up to 30 or more per transaction number. I have to import my transactions into a personal finance software and need my data to be setup correctly in order to be imported properly as I don't want to lose my historical transaction.

I need to a VBA solution to extract the data per trx number, sum it up and pull out all the splits for that trx number and bring in to columns adjacent.
I have attached an example of my data with how the raw data is setup and my desired result.

Thanks in advance.

[PCI]

From your example it seems that for the same TRXN , the PAYEE, LOCAT are always the same, is it ?

Added : Date and ACT1 and PAYEE and LOCAT

[PCI]

See next code.
See in file attached sheets'name used

Please Login or Register  to view this content.

[jindon]

See

Transpose split data from rows to columns