Hello,
In the example below, I'm trying to cross tab portion of the data (GL account and Amount) only and the desired output would be: vendor no., vendor name, invoice no., invoice date, due date, routing code, (1st) gl account for the same vendor, (1st) amount for the same vendor, (2nd) gl account for the same vendor, (2nd) amount for the same vendor, etc. on 1 row. When there is a change in vendor number, a new row would be created for the new vendor interation. I feel like an iterative macro is needed but not sure where to start - any advice is greatly appreciated!
