Related:
- Spliting lines of data in a cell into columns
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Gta 5 data download for pc - Download - Action and adventure
- Digital data transmission - Guide
- Amd data change update new data to dmi ✓ - Windows 10 Forum
1 response
Hi Fanfan,
I am not sure how you would like your data to look like, but let me give you some tools which may get the job done.
Separate heading from data:
Select your data, goto the top menu's Data, select Text Delimiter, click next on the screen that pops up, select remainder and enter ":". Now the example shows how your data is going to look like. Click finish and you are done.
Change column to rows:
Copy your data, right click, paste special, transpone (option at the bottom right) and click OK.
Can you do something with this?
Best regards,
Trowa
I am not sure how you would like your data to look like, but let me give you some tools which may get the job done.
Separate heading from data:
Select your data, goto the top menu's Data, select Text Delimiter, click next on the screen that pops up, select remainder and enter ":". Now the example shows how your data is going to look like. Click finish and you are done.
Change column to rows:
Copy your data, right click, paste special, transpone (option at the bottom right) and click OK.
Can you do something with this?
Best regards,
Trowa
