moving every other row up 1 row to the next column

R

Rose Davis

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'
 
R

Rose Davis

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
 
K

Ken Wright

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 :)
------------------------------­------------------------------­----------------
 
K

Ken Wright

See my post

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

Rose Davis said:
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
 
R

Rose Davis

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
 
K

Ken Wright

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........................
 
R

Rose Davis

I'm such a spaz, thanks
Ken Wright said:
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........................
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top