Transform column to row
Patlechat
-
celinedidi -
celinedidi -
Hello,
I have an Excel document where I copied and pasted data, and this data is in a single column like this:
Name1
Address1 postalcode1 city1
Name2
Address2 postalcode2 city2
.....
I would like to format it in a single line like this:
Name1 | Address1 | postalcode1 | city1
Name2 | Address2 | postalcode2 | city2
How can I do this?
Thank you for your help.
See you later
I have an Excel document where I copied and pasted data, and this data is in a single column like this:
Name1
Address1 postalcode1 city1
Name2
Address2 postalcode2 city2
.....
I would like to format it in a single line like this:
Name1 | Address1 | postalcode1 | city1
Name2 | Address2 | postalcode2 | city2
How can I do this?
Thank you for your help.
See you later
Configuration: Windows Vista Firefox 2.0.0.8
4 réponses
Hello
Here is the answer I found
Select the cells whose orientation you want to reverse.
Click on Copy.
Select the upper left cell of the paste area. This should be outside the copy area.
Click on the arrow to the right of the Paste button, then click on Transpose.
Good luck
Here is the answer I found
Select the cells whose orientation you want to reverse.
Click on Copy.
Select the upper left cell of the paste area. This should be outside the copy area.
Click on the arrow to the right of the Paste button, then click on Transpose.
Good luck
zied
merc
Anthy92
it still works for Excel 2013
celinedidi
Thank you very much!