Code to Cut and Paste Data to the Row Above

[perryjasonc]

If my data looks like what I have below, I would like for excel to be able to identify that the second row starts with "F5102" then cut and paste that data to the end of the row above it that starts with "F5101". Then do that for everything that starts with "F51##" until it finds an "F5101" again. Then I can use Text to Columns after that the break apart the string as needed.

F51010058 080705P2031234567890
F51020058SCHOLARSCHOICECOLLEGESVGSPRGM
F51030058FBOJOHNDOE
F51010058 080705P2031234567890
F51020058SCHOLARSCHOICECOLLEGESVGSPRGM
F51030058FBOJOHNDOE

 

[Macropod]

This is a duplicate of your post here: https://www.mrexcel.com/forum/excel...ng-record-layout-post4956143.html#post4956143
As per Rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html), kindly don't post duplicate questions.

Thread closed. You may continue the discussion in your other thread.