transposing data from 1 column into multiple rows
 

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

transposing data from 1 column into multiple rows
 

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

transposing data from 1 column into multiple rows
 

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!