Sorting rows to match headings
 

I have several columns of data each with its own heading. I need to get the
data within each column to match its respective heading.

Here's a sample of how it looks now:

Headings: Alaska Asia Canada Caribbean Not
Specified
Row 1: Canada Caribbean
Row 2: Alaska Canada Caribbean
Row 3: Not Specified

Here's how I'd like it to look:

Headings: Alaska Asia Canada Caribbean Not
Specified
Row 1: Canada Caribbean
Row 2: Alaska Canada Caribbean
Row 3:
Not Specified

I'm on Excel 2002. Hopefully, someone can help!

Sorting rows to match headings
 

One play to try ..

Assuming the source table as posted is in Sheet1, cols A to E,
col headers in A1:E1, data from row2 down

In another Sheet2,
Copy & paste the same col headers into A1:E1

Then put in A2:
=IF(ISNUMBER(MATCH(A$1,Sheet1!2:2,0)),A$1,"")
Copy A2 across to E2, fill down as far as required

This should return the desired results .. If necess. freeze the results by
selecting cols A to E, then do an "in-place": Copy Paste special Check
Values OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kconnelly" wrote:
I have several columns of data each with its own heading. I need to get the
data within each column to match its respective heading.

Here's a sample of how it looks now:

Headings: Alaska Asia Canada Caribbean Not
Specified
Row 1: Canada Caribbean
Row 2: Alaska Canada Caribbean
Row 3: Not Specified

Here's how I'd like it to look:

Headings: Alaska Asia Canada Caribbean Not
Specified
Row 1: Canada Caribbean
Row 2: Alaska Canada Caribbean
Row 3:
Not Specified

I'm on Excel 2002. Hopefully, someone can help!