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.