Glad you liked it.
Just so you don't misunderstand me. If you add number and letters to rows that is missing a number when you do a "Find" and Replace part you don't write anything in the "Replace" part. My explanation in the file was a bit muddeled I think.
To get rid of blank row you could add this macro
Perhaps you could run this macro first and then the "transpose_row" macro. As this will reduce the number of "Check for ...." messages.
After fixing rows with missing number and removing the number and letters you added delete column A and run "delete_empty_rows"
If you liked my solution you can click on the star in my post and give a rating to my answer.
Alf
Ps I liked you problem it was quite a bit of fun working with it!
Bookmarks