Related:
- Spliting lines of data in a cell into columns
- Tmobile data check - Guide
- Excel multiple lines in one cell - Guide
- Sed delete lines - Guide
- Based on the cell values in cells b77 ✓ - Excel Forum
- Commandos behind enemy lines download - Download - Strategy
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
