transposing data from 1 column into multiple rows

[Gina]

This question has been posed before, but the responses didn't work for my
spreadsheet?

I have data:
1
2
3
4
5
6
7
8
9
in column A. It repeats over and over, different info, same format. I'd like
it to read:

1 2 3 4 5 6 7 8 9
1 2 3 4 5 6 7 8 9
etc. Please help!

 

[Teethless mama]

Select your range >> right click to Copy >> select a blank cell right click
Paste Special >> select Transpose >> OK

Select the transpose range and copy down

 

[Domenic]

Assuming that A1:A45 contains the data, try...

B1, copied down and across:

=INDEX($A$1:$A$45,(ROWS(B$1:B1)*9-9+1)+(COLUMNS($B1:B1)-1))

Hope this helps!