Data Sort with Two Rows

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Can this be done? Say row one and two have data that
belong together, but I need to sort this file by
something on the first row. Can I do this without
creating a whole new sheet, which would move row two up
to row one?
 
Wendy

Select your two rows.

Data>Sort>Options "sort left to right"

Gord Dibben Excel MVP
 
Nope that wasn't right. Here's an example of the data.

Name Address
City State
Me Here
Walla WA
You There
Detroit MI
Us Somewhere
Flint MI

Each two rows go together and I want them to stay
together, and I want to sort this list by name.
 
Wendy,

I doubt there's anything that will sort such a freeform table. You should
get it into a standard one-row-per-item format, with headings. There's
plenty of functionality in Excel that will work then.

Name Address City State
Me Here Walla WA
You There Detroit MI
Us Somewhere Flint MI

If you need to print it in some other layout, Access or Word can do it using
your Excel data.
 
Back
Top