I have data all in 1 column and want to transfer it to a
table.
In cell A1 - there is text and then the next 9 cells below
have numbers. Cell A11 has text again andthe next cells
below have numbers. I want to convert this into a table.
E.G.
Name1
1
2
3
4
5
6
7
8
9
Name2
10
11
12
13
14
15
16
17
18
Name3 etc... It goes up to Name150 (approximately)

turn into

Name1 1 2 3 4 5 6 7 8 9
Name2 10 11 12 13 14 15 16 17 18
Name3.....


Thanks