Hi,

I have just subtotaled an inventory spreadsheet at work and now have 13,000
lines of data. Now that I have the subtotals by inventory item, I want sort
so that I have all the subtotals together as a group, and all the data that
went into the subtotals separated out. But Excel refuses to do this, even
though I have two columns that I would be able to do this by because the
subtotals have nothing in those two columns and the other lines do have data
in those two columns. I am very frustrated, because going through 13,000
lines of data to delete this information by hand will be extremely
time-consuming!!! Please help!!!

Thank you,
Katherine