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

"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!

--
Gina