[RESOLVED] Copy Paste Excel

Is there a way to copy a column and paste it on a row.

I know it is possible by using 2 loops and vba, but is there a way in excel, non vba macro.

Thanks

You can lookup Transpose in the function list and review the help on this function

exactly what I needed.

Thanks

It is tricky however..

Using transpose on the same sheet is tricky due to overlapping when pasting.
But if you paste on a new sheet, worked like a standard copy paste.