Thread: Copy Horizontal to Paste Vertical and vice versa

Hello,
Sorry- I should have started my own post for help on this! Not sure how to delete my previous post (asked a question on someone else's thread).

I need to copy a row of cells, and paste that row elsewhere on the sheet as a column of cells.
I can do the right click and 'paste special' and check the box for transpose, but I can't get the second option given in the other thread to work.

The option given was to use =TRANSPOSE(array). then hit ctr+shift+enter.

Do I need to fill down somehow?
I did hit ctl+shift+enter, which added the {} symbol, but it only fills in the cell I am in.

Thanks,
Jenrich

(See other post: Copying Horizontal to paste vertical)

I would be inclined to use INDEX rather than TRANSPOSE.

Say you're original date was Sheet1!1:1 and you want to transpose that into Sheet2!A:A

Sheet2!A1: =INDEX(Sheet1!$1:$1,ROWS(A$1:A1))
copied down

will transpose data without need for Arrays etc...