Hello All,
I am using Office XP and have the following problem. On Sheet1 I have
several thousand rows of data in the following format:
A B
1 Data1 Data11
2 Data2 Data12
3 Data3 Data13
4 Data4 Data14
5 Data5 Data15
6 Data6 Data16
7 Data7 Data17
8 Data8 Data18
9 Data9 Data19
10 Data10 Data20
11 <blank row
12 Data21 Data31
13 Data22 Data32
14 Data23 Data33
15 Data24 Data34
16 Data25 Data35
17 Data26 Data36
18 Data27 Data37
19 Data28 Data38
20 Data29 Data39
21 Data30 Data40
22<blank row
....... and so on
As can be seen from above the data is evenly distributed in set of 10 Rows
each followed by a <blank row.

I wish to have the above data on Sheet2 Col A in the following format :
Data1
...
...
Data 10
Data 11
....
Data 20
Data 21
....
Data 30
.....
Data 40
I would preferably like to Make a selection prior to running the macro to
have better control.. as the matter is several thousand rows.
Can this be done?
Any help or suggestions would be greatly appreciated
TIA
Rashid Khan