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!

In article ,
Gina wrote:

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!