Automatically transpose

[amy]

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

 

[Frank Kabel]

Hi
on your second sheet enter the following in cell A1
=OFFSET('sheet1'!$A$1,COLUMN()-1+(ROW()-1)*10,0)
and copy this down and to the right.

After this you may copy this range and insert it with 'Edit - Paste
Special - Values' to remove the formulas