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)
Bookmarks