Combine consecutive Rows

[prkhan56]

I posted this message yesterday but it is not to be seen.. so posting
again..



Hello All,
I am using Office XP and have the following problem.

I have downloaded some data from the Internet as follows:

E.g.
1 Aaa
2 Bbb
3 Ccc
4 Ddd
5 Eee
6 Fff
7 Ggg
8 Hhh
....
....
....
...

I wish to combine data of consecutive rows as follows:

1 Aaa Bbb
2 <Blank>
3 Ccc Ddd
4 <Blank>
....
....
..
At present I am using Edit-Cut-Paste. I hope there is a macro which
can run on consecutive rows (which I can select if required) and have
the results as desired.

I have seen the threads and there are many macros and most of them use
a common value in Column A...In my case there is no common value.. I
just need to combine consecutive rows as shown above

At present it takes up lot of time as there are several hundred rows
to work with.

Thanks in advance.

Rashid Khan

 

[prkhan56]

Hello All,
Sorry to all...my problem was answered and it works
perfectly ....thanks to all who have replied
My apologies for reposting...

You guys are great

Thanks once again