Macro to move data from one cell to another where unique identifier changes

I am looking for a Macro that will enable me to move data from cells on the row below to the cells directly above upon the change of a unique identifier (CRN). This is probably a little confusing so I have attached a copy of the data that I am working with along with the desired output. I am looking to move the textbook information on to the same line as the course information rather than having it all on separate lines. At each change in CRN the next blank lines (column A) would be moved to the appropriate course.

The attachment only contains a few courses, I can't do this manually given there are about 12000 records in total in my master spreadsheet. Unfortunately this is just how the data is extracted from the system.

Any help would be greatly appreciated.

Thanks

Chris

Hi ,

I made a serious effort on this .. I have kept a Button1 in sheet "Sheet1" , output shall be derived in sheet2

Please Login or Register  to view this content.

Hope this would help you !

Please rate if it works !

sorry did not attach the file in my previous reply !!

here attached !