There is nothing that stops you from doing that, except that you will have
blank cells for those zip codes in which no houses were sold in the
particular month?
A complete list of zip codes in Col A, of course, and then quantities in the
other columns.

85003 2 2
85006 7 3
85007 2 2
85008 9 3
85009 1 3
85012 2
85013 2 1
85014 7 3
85015 5 6
85016 7 15
85017 4 3
85018 15 6
85019 4 3
85020 6 10
85021 4 8
85022 5 13
85023 7 4
85024 5

Say you have headings in row 1. Move cursor to B2, click on View, Freeze
panes, and you will always have the zipcodes visible, even if you move over
to the right.

--
HTH

Kassie

Replace xxx with hotmail


"moparfamily" wrote:

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.