Sorting rows to match headings

[kconnelly]

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!

 

[Max]

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