SandsB
Well-known Member
- Joined
- Feb 13, 2007
- Messages
- 705
- Office Version
- 365
- Platform
- Windows
I get an output file from a system that can't be changed before I get it. It has 5 columns. The output file frequently has data for one item on multiple rows - the last column is the only thing that's different. I need a macro to read in my file, if a record is in the report with more than 1 row (based on the unique Record #) - take that last field of that last duplicate record and put it in column 5, take the next record and put that 5th field in column 6, and so on. (So the values will appear in a row but in the reverse order of the way thaey appeared when in colums) There may be as many as 11 rows for the same record.
Sample input file:
11305 Bob Mary Sue 100
11306 Jim Art Jan 200
11306 Jim Art Jan 300
11306 Jim Art Jan 900
11307 Howard Mark Gertrude 515
What I'd like as my new file is:
11305 Bob Mary Sue 100
11306 Jim Art Jan 900 300 200
11307 Howard Mark Gertrude 515
Thanks in advance and a happy new year to all my Excel buddies all over the world.
Sample input file:
11305 Bob Mary Sue 100
11306 Jim Art Jan 200
11306 Jim Art Jan 300
11306 Jim Art Jan 900
11307 Howard Mark Gertrude 515
What I'd like as my new file is:
11305 Bob Mary Sue 100
11306 Jim Art Jan 900 300 200
11307 Howard Mark Gertrude 515
Thanks in advance and a happy new year to all my Excel buddies all over the world.