View original (French)

Transform column to row

Patlechat -  
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

  • Votes
  • Date
  • Descending date
  1. Yechau
    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
    2. Anthy92
      it still works for Excel 2013
    3. celinedidi
      Thank you very much!
  3. Yechau
    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. nana
      Thank you very much for your help. I am very satisfied with the result.