So I have about 1,000 rows of data where two rows are pairs. What I need to do is cycle through the 1,000 rows and bring up the bottom paired row to the next available column in the top paired row.
It is probably easier to see what I'm talking about rather than explain so I have attached a workbook with a before and after tab.
Thanks.
One way...
Please Login or Register to view this content.
Last edited by sintek; 01-03-2018 at 11:52 AM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Perfect! Thank you!Originally Posted by sintek
One way...
Please Login or Register to view this content.
Glad I could help...Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks