Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting rows based upon formatting | Excel Discussion (Misc queries) | |||
sorting a sheet with outlined rows | Excel Discussion (Misc queries) | |||
Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
sorting a constantly changing set of rows in VBA | Excel Discussion (Misc queries) | |||
Sorting rows with alphanumeric starter cells | Excel Worksheet Functions |