New

Turn data in one single row into several columns

  Excel
Morais
  Morais
  Friday, 24 March 2023
  2 Replies
  4.1K Visits
0
Votes
Undo
Hi,

I have this data in one row in excel, exactly in this format (text, than a blank line, than text and so on :

Atlanta

Orlando

New York

How can I turn this date into multiple columns or different rows?

Thanks
0
Oldest First  
Amanda Lee
Amanda Lee
1 year ago
·
#3458
0
Votes
Undo
Hi there,

You can copy the row that contains the data, and then right-click on a blank cell, and select Transpose from the Paste Options as shown below:
transpose.png

You will get the data in different rows:
transposed.png

If you have any further questions, please don't hesitate to ask me.

Amanda
Morais
Morais
1 year ago
·
#3460
0
Votes
Undo
Hi, Thanks for the help but that does not help as I have several data in the same row, not different rows. But I did manage to find the solution with the "split cells" option.
Many many thanks
Rgds,
Elisa
  • Page :
  • 1
There are no replies made for this post yet.