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!