P
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
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