sorting rows

[staceyt79]

I am needing to sort the following example by rows. I need to keep the data between the lines together though.

121624321 222 555 777 3222
21 oz lid
_______________________________________
107624114 325 333 55 777
7 oz lid
______________________________________

I've got an entire worksheet of these and I need to be sure that the information between the lines stays together.

 

[mikerickson]

You you post a small (< 10 records) sample of your workbook? (this links to a tool for that http://www.puremis.net/excel/downloads.shtml)
and the result you want? i.e. sort on what and what you want if there is a tie.