Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining Uneven Columns
I have a worksheet that has 6 months of data (2 columns for each month) the
first column for each month is zip codes and 2nd column is how many homes sold in each zip code for that month. I want to have just 1 column for the zip codes but yet keep the amount of houses sold in each zip code separate for each month. The problem being is that the same zip codes did not have sales each month. So my columns are uneven and not in the same order. I'm guessing there is a way to do this without manually matching each column up. -- Sandee Here is just 2 months (I have a total of 6 months) Zip January Zip Feb 85003 2 0 2 85006 7 85006 3 85007 2 85007 2 85008 9 85008 3 85009 1 85009 3 85012 2 85013 1 85013 2 85014 3 85014 7 85015 6 85015 5 85016 15 85016 7 85017 3 85017 4 85018 6 85018 15 85019 3 85019 4 85020 10 85020 6 85021 8 85021 4 85022 13 85022 5 85023 4 85023 7 85024 5 So I want just Column A to be Zip Codes Column B for January sales Column C for Feb Sales. . but I don't want to list the zip codes every month. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining columns | Excel Discussion (Misc queries) | |||
Combining Text from 2 Columns into 1 then Deleting the 2 Columns | Excel Worksheet Functions | |||
Charting xy scatter of uneven columns of data | Charts and Charting in Excel | |||
lookup with uneven columns | Excel Worksheet Functions | |||
combining columns all the way down | Excel Discussion (Misc queries) |