Sorting multiple rows at a time

[Tekture]

The sort function (as far as i can tell) will only sort 1 row at a time based on contents of column selected. So say you have 3 rows of data that should be treated as if they were one. How would you be able to sort 3 rows at a time?

In my situation, for example, D1=1 and D7=2 but all the cells in between are blank (which makes this easier) The best i can come up with is to put in those blank cells the following: D1=1, D2=1a, D3=1b, D4=1c, etc... (cell contents are unique item numbers)

 

[Brianwarnock]

I don't understand the reference to 3 rows if you then say D1=1 and D7 =2 and all between are blank.

Your proposed solution only works if all of the original numbers are of the same length as you will now be doing an alpha sort where 11 comes before 2, for example.

Brian

 

[Tekture]

Ahh, yes, i'm sorry. The total number of rows in one section is 7 and yes every section is the same length throughout the report. The unique item numbers are not all the same length though. Some are 4 numbers and others are 5.