[RESOLVED] Copy Paste Excel

[billhuard]

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

[dannymking]

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

[billhuard]

exactly what I needed.

Thanks

[dannymking]

It is tricky however..

[billhuard]

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.