Excel Query - Rows to Column

[gary-postman]

Hi
I'm sure that there is an easy way to do what I would like but I am unable to work it out and would be grateful for your help.

I have three rows of numbers (all different) that I would like to duplicate in a column on the same work sheet. Each cell has its own number. An example is - A1 = 123 B1 = 231 C1 = 234 and so on. A2 = 24 B2=35 C2 = 46 and so on. A3 = 342 B3 = 435 C3 = 334 and so on along the Row. There are three Rows.
I would like to copy the Rows to Columns on the same sheet. As in A1 copied to A10, A2 copied to B10, A3 copied to C10.
I hope that I've explained, clearly, what I want to do.

Many thanks to those that are able to help.

Gary

 

[Paul Wakefield]

Sorry, I'm a bit into el vino. But if I've understood correctly:

Highlight the range you want to transpose
Ctrl C (or Copy)
Go to the first cell you want to put the rearranged data in
Edit - Paste Special - tick the "Transpose" option and Enter.

If I've missed the point, let me know and I'll give it more thought.

HTH.

Paul

 

[gary-postman]

Excel Query

Hi Paul

Your answer worked a treat. Many thanks.

Take care

Gary