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.

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.

That isn't my question. I know that there will be blanks. What I'm asking
is how do I merge the 6 lists of zip codes (some months have 100 zip codes
some have 159 zip codes) so obviously they are not in the same order. Other
than manually moving and inserting the zip codes into one column andmaking
sure that the sales count stays in the correct row. . I am hoping I don't
have to do each one manually. I'm looking for a function to help me with
that. I need to merge the zip codes but leave the number of houses sold in
the correct row with the zip code.
--
Sandee


"Kassie" wrote:

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.