View original (French)

Transform column to row

Patlechat -  
 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 
Configuration: Windows Vista Firefox 2.0.0.8

4 answers

  1.
    Yechau Posted messages 26 Status Member 18
     
    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
    18
    1. zied
       
      merc
      0
    2. Anthy92
       
      it still works for Excel 2013
      0
    3. celinedidi
       
      Thank you very much!
      0
  3. Yechau Posted messages 26 Status Member 18
     
    Hello

    After several attempts, here is what is missing from the previous explanations
    Select an empty range, starting with the cell containing the formula. Press F2, then CTRL+SHIFT+ENTER.

    Best regards
    1
  4. nana
     
    Thank you very much for your help. I am very satisfied with the result.
    0