Quote Originally Posted by Alf View Post
Perhaps like this? This macro first makes a copy of sheet1 named sheet2. Macro then removes all blank rows and rows that contains text i.e. "/" in Sheet2.

The remaining rows in Sheet2 are transposed to a new sheet called "Sorted", the "breaking point" for a new bath of rows ro transpose is the "@" sign. After all rows is transposed to sheet "Sorted", Sheet2 is deleted leaving the original sheet (Sheet1) and the sorted result in sheet "Sorted".

To test run macro "Sorter".

Alf
You are really a wizard! Saved me a bunch of work!
Thanks!