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
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- How to reset safe folder password without losing data ✓ - Android 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
