Green,

If the two records don't have the same identifying entry in the column on
which you need to sort the table, you can't. And if it does, you'll still
probably need to have something in some column whereby you can distinguish
the two record types. Excel doesn't really have any tools for multiple
record types.

If not, that is, if the second record can be identified only by it's
position immediataly after it's matching first record, your best bet is to
combine them with a formula. In fact, you may wish to do that anyway, to
avail yourself of other tools you may want to use (Pivot tables, Subtotals,
Filtering, etc.). Post back. Give an example of a pair of matching
records.
--
Earl Kiosterud
www.smokeylake.com

"GreenPower" wrote in message
...
A Report that I imported into Excel 2003 (for sorting the records) comes in
with some of the fields on a second row. How can I sort these records?