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
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
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:
You will get the data in different rows:
If you have any further questions, please don't hesitate to ask me.
Amanda
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:
You will get the data in different rows:
If you have any further questions, please don't hesitate to ask me.
Amanda
- Page :
- 1
There are no replies made for this post yet.