Cell manipulation

[Kevin G]

I have a spreadsheet with 20 rows of data. The data is
one cell in length and goes from cell A1 to A20. What I'm
wondering is if there's a formula or function that I can
use to take the data that is in cell A2 and move it to B1
and likwise down the list -- A3 to C1, A4 to D1. This 20
item list is a very small one. I'm going to be working
with 200 items and larger and need to do the same thing.

Any help is appreciated.

Thanks,

Kevin G

 

[drabbacs]

copy. paste-special in a blank cell with transpose
selected.

 

[Marc]

Sounds like you want to transpose the data...
select your data, copy, then select Paste special -
transpose