Converting rows of data in notepad to columns
Solved/Closed
Related:
- How to convert row to column in notepad++
- Transpose in notepad++ - Best answers
- Notepad++ transpose row to column - Best answers
- Convert m3u to mp3 - Guide
- How to convert number to words in word - Guide
- How to open excel in notepad - Guide
- How to convert free fire id facebook to google - Guide
- Convert picture to shape powerpoint - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Updated on Nov 26, 2019 at 05:33 PM
Updated on Nov 26, 2019 at 05:33 PM
Highlight data in the notepad and hit: edit copy
Go to an excel sheet cell A1 hit: edit paste
Highlight the whole date in excel
Click data(menu)-text to columns
Choose "delimited" click next
Choose "others" and type in the small window a colon(:)
Click finish
Again highlight data
Edit copy
Go to another sheet A1
Edit-pastepeical-transpose
Now highlight data in second sheet click format(menu)-columns-autofit
Now you have to tweak the data because you have line like
Home Phone: Work Phone: 0799172800
It should be:
home phone
workphone:0799172800
See help text to columns
Go to an excel sheet cell A1 hit: edit paste
Highlight the whole date in excel
Click data(menu)-text to columns
Choose "delimited" click next
Choose "others" and type in the small window a colon(:)
Click finish
Again highlight data
Edit copy
Go to another sheet A1
Edit-pastepeical-transpose
Now highlight data in second sheet click format(menu)-columns-autofit
Now you have to tweak the data because you have line like
Home Phone: Work Phone: 0799172800
It should be:
home phone
workphone:0799172800
See help text to columns