moving every other row up 1 row to the next column

I need to move every other row to match with the one above it but place it
the info in the next column.
Column A Column B
Description
F8430566
PREMARK 24'' WH LN + 15'
F8431064
PREMARK 12'' WH LINE PLUS 30'

What I need is:

F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'

Try something like the "Vertical to horizontal..." here:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Rose Davis" <[email protected]> wrote in message
news:%[email protected]...
>I need to move every other row to match with the one above it but place it
> the info in the next column.
> Column A Column B
> Description
> F8430566
> PREMARK 24'' WH LN + 15'
> F8431064
> PREMARK 12'' WH LINE PLUS 30'
>
> What I need is:
>
> F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
>
>
>

Thanks for the suggestion. But I have 5200 rows and each row has different
information. I need to take the description and place it beside the product
# and have the second row become blank.
Thanks for any help
"Anne Troy" <[email protected]> wrote in message
news:%[email protected]...
> Try something like the "Vertical to horizontal..." here:
>
http://www.officearticles.com/excel/...soft_excel.htm
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Rose Davis" <[email protected]> wrote in message
> news:%[email protected]...
> >I need to move every other row to match with the one above it but place
it
> > the info in the next column.
> > Column A Column B
Product #
> > Description
> > F8430566
> > PREMARK 24'' WH LN + 15'
> > F8431064
> > PREMARK 12'' WH LINE PLUS 30'
> >
> > What I need is:
> >
> > F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
> >
> >
> >
>
>

Assuming your data is in A1:A1000

Insert a column such that your data is now in Col B
In your new A1 put a header abc
In cell A2 put =MOD(ROW(),2) and copy down as far as necessary.

Copy the whole of Column B and paste it into Column C such that the two
columns of data are exactly the same and side by side.
Select cell C1 and do edit / delete / Shift cells up

What will have just happened is that all your data on every other row now
looks just like you want it to.

Copy Col A and then paste special as values

Select Col A and do data / Filter / Autofilter, and assuming you had headers
in row 1 in cell A3 you should see the first row of data you don't want, and
in cell A3 you will see a 1 so filter on 1s.

Now select A2:A100 or whatever the last row of data you can see is. Then do
edit / Go To / Special / Visible cells only, then do Edit / delete / Entire
Row.

Take the filter off of Col A and you are done.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Rose Davis" <[email protected]> wrote in message
news:%[email protected]...
>I need to move every other row to match with the one above it but place it
> the info in the next column.
> Column A Column B
> Description
> F8430566
> PREMARK 24'' WH LN + 15'
> F8431064
> PREMARK 12'' WH LINE PLUS 30'
>
> What I need is:
>
> F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
>
>
>

See my post

Regards
Ken.................

"Rose Davis" <[email protected]> wrote in message
news:[email protected]...
> Thanks for the suggestion. But I have 5200 rows and each row has
> different
> information. I need to take the description and place it beside the
> product
> # and have the second row become blank.
> Thanks for any help
> "Anne Troy" <[email protected]> wrote in message
> news:%[email protected]...
>> Try something like the "Vertical to horizontal..." here:
>>
> http://www.officearticles.com/excel/...soft_excel.htm
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "Rose Davis" <[email protected]> wrote in message
>> news:%[email protected]...
>> >I need to move every other row to match with the one above it but place
> it
>> > the info in the next column.
>> > Column A Column B
> Product #
>> > Description
>> > F8430566
>> > PREMARK 24'' WH LN + 15'
>> > F8431064
>> > PREMARK 12'' WH LINE PLUS 30'
>> >
>> > What I need is:
>> >
>> > F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
>> >
>> >
>> >
>>
>>
>
>

Everything's has worked until I get to this part.

Do I copy Col A back into Col A or where.
When I GO TO for Visible Cells Only, it says the cells are already visible.
Is this what I am supposed to see.
Thanks

"Ken Wright" <[email protected]> wrote in message
news:[email protected]...
> Assuming your data is in A1:A1000
>
> Insert a column such that your data is now in Col B
> In your new A1 put a header abc
> In cell A2 put =MOD(ROW(),2) and copy down as far as necessary.
>
> Copy the whole of Column B and paste it into Column C such that the two
> columns of data are exactly the same and side by side.
> Select cell C1 and do edit / delete / Shift cells up
>
> What will have just happened is that all your data on every other row now
> looks just like you want it to.
>
> Copy Col A and then paste special as values
>
> Select Col A and do data / Filter / Autofilter, and assuming you had
headers
> in row 1 in cell A3 you should see the first row of data you don't want,
and
> in cell A3 you will see a 1 so filter on 1s.
>
> Now select A2:A100 or whatever the last row of data you can see is. Then
do
> edit / Go To / Special / Visible cells only, then do Edit / delete /
Entire
> Row.
>
> Take the filter off of Col A and you are done.
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------*------------------------------*------------
----
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------*------------------------------*------------
----
>
>
> "Rose Davis" <[email protected]> wrote in message
> news:%[email protected]...
> >I need to move every other row to match with the one above it but place
it
> > the info in the next column.
> > Column A Column B
> > Description
> > F8430566
> > PREMARK 24'' WH LN + 15'
> > F8431064
> > PREMARK 12'' WH LINE PLUS 30'
> >
> > What I need is:
> >
> > F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
> >
> >
> >
>
>

To be honest you probably don't even need to copy and paste A back, but yes
i meant to copy and paste exactly where it was, simply in order to lose the
formulas and hardwire the results. the idea is that you end up with data
looking like this:-

A B C
1 xyz abc
0 abc xyz
1 xyz abc
0 abc xyz
1 xyz abc
0 etc

Then you apply data / filter / autofilter to Col A and filter on the 1s or
the 0s depending on which rows you DONT WANT. This will leave showing just
the rows you DON'T WANT, eg assuming it was the 1s you DONT WANT then choose
1 in the filter and you will now see:-

A B C
1 xyz abc
1 xyz abc
1 xyz abc

This is when you now select all you can see in Col A, and then do edit / Go
to / visible cells only, and then edit / delete / entire row.

then just take the filter off and you are left with what you actually want.

Regards
Ken........................


"Rose Davis" <[email protected]> wrote in message
news:[email protected]...
> Everything's has worked until I get to this part.
>
> Do I copy Col A back into Col A or where.
> When I GO TO for Visible Cells Only, it says the cells are already
> visible.
> Is this what I am supposed to see.
> Thanks
>
> "Ken Wright" <[email protected]> wrote in message
> news:[email protected]...
>> Assuming your data is in A1:A1000
>>
>> Insert a column such that your data is now in Col B
>> In your new A1 put a header abc
>> In cell A2 put =MOD(ROW(),2) and copy down as far as necessary.
>>
>> Copy the whole of Column B and paste it into Column C such that the two
>> columns of data are exactly the same and side by side.
>> Select cell C1 and do edit / delete / Shift cells up
>>
>> What will have just happened is that all your data on every other row now
>> looks just like you want it to.
>>
>> Copy Col A and then paste special as values
>>
>> Select Col A and do data / Filter / Autofilter, and assuming you had
> headers
>> in row 1 in cell A3 you should see the first row of data you don't want,
> and
>> in cell A3 you will see a 1 so filter on 1s.
>>
>> Now select A2:A100 or whatever the last row of data you can see is. Then
> do
>> edit / Go To / Special / Visible cells only, then do Edit / delete /
> Entire
>> Row.
>>
>> Take the filter off of Col A and you are done.
>>
>> --
>> Regards
>> Ken....................... Microsoft MVP - Excel
>> Sys Spec - Win XP Pro / XL 97/00/02/03
>>
>> ------------------------------*------------------------------*------------
> ----
>> It's easier to beg forgiveness than ask permission :-)
>> ------------------------------*------------------------------*------------
> ----
>>
>>
>> "Rose Davis" <[email protected]> wrote in message
>> news:%[email protected]...
>> >I need to move every other row to match with the one above it but place
> it
>> > the info in the next column.
>> > Column A Column B
>> > Description
>> > F8430566
>> > PREMARK 24'' WH LN + 15'
>> > F8431064
>> > PREMARK 12'' WH LINE PLUS 30'
>> >
>> > What I need is:
>> >
>> > F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
>> >
>> >
>> >
>>
>>
>
>

I'm such a spaz, thanks
"Ken Wright" <[email protected]> wrote in message
news:[email protected]...
> To be honest you probably don't even need to copy and paste A back, but
yes
> i meant to copy and paste exactly where it was, simply in order to lose
the
> formulas and hardwire the results. the idea is that you end up with data
> looking like this:-
>
> A B C
> 1 xyz abc
> 0 abc xyz
> 1 xyz abc
> 0 abc xyz
> 1 xyz abc
> 0 etc
>
> Then you apply data / filter / autofilter to Col A and filter on the 1s or
> the 0s depending on which rows you DONT WANT. This will leave showing
just
> the rows you DON'T WANT, eg assuming it was the 1s you DONT WANT then
choose
> 1 in the filter and you will now see:-
>
> A B C
> 1 xyz abc
> 1 xyz abc
> 1 xyz abc
>
> This is when you now select all you can see in Col A, and then do edit /
Go
> to / visible cells only, and then edit / delete / entire row.
>
> then just take the filter off and you are left with what you actually
want.
>
> Regards
> Ken........................
>
>
> "Rose Davis" <[email protected]> wrote in message
> news:[email protected]...
> > Everything's has worked until I get to this part.
> >
> > Do I copy Col A back into Col A or where.
> > When I GO TO for Visible Cells Only, it says the cells are already
> > visible.
> > Is this what I am supposed to see.
> > Thanks
> >
> > "Ken Wright" <[email protected]> wrote in message
> > news:[email protected]...
> >> Assuming your data is in A1:A1000
> >>
> >> Insert a column such that your data is now in Col B
> >> In your new A1 put a header abc
> >> In cell A2 put =MOD(ROW(),2) and copy down as far as necessary.
> >>
> >> Copy the whole of Column B and paste it into Column C such that the two
> >> columns of data are exactly the same and side by side.
> >> Select cell C1 and do edit / delete / Shift cells up
> >>
> >> What will have just happened is that all your data on every other row
now
> >> looks just like you want it to.
> >>
> >> Copy Col A and then paste special as values
> >>
> >> Select Col A and do data / Filter / Autofilter, and assuming you had
> > headers
> >> in row 1 in cell A3 you should see the first row of data you don't
want,
> > and
> >> in cell A3 you will see a 1 so filter on 1s.
> >>
> >> Now select A2:A100 or whatever the last row of data you can see is.
Then
> > do
> >> edit / Go To / Special / Visible cells only, then do Edit / delete /
> > Entire
> >> Row.
> >>
> >> Take the filter off of Col A and you are done.
> >>
> >> --
> >> Regards
> >> Ken....................... Microsoft MVP - Excel
> >> Sys Spec - Win XP Pro / XL 97/00/02/03
> >>
>
>> ------------------------------*------------------------------*-----------
-
> > ----
> >> It's easier to beg forgiveness than ask permission :-)
>
>> ------------------------------*------------------------------*-----------
-
> > ----
> >>
> >>
> >> "Rose Davis" <[email protected]> wrote in message
> >> news:%[email protected]...
> >> >I need to move every other row to match with the one above it but
place
> > it
> >> > the info in the next column.
> >> > Column A Column B
> >> > Description
> >> > F8430566
> >> > PREMARK 24'' WH LN + 15'
> >> > F8431064
> >> > PREMARK 12'' WH LINE PLUS 30'
> >> >
> >> > What I need is:
> >> >
> >> > F8432060SP4 PREMARK 4''X4' STRIPS WH 3000'
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>
>