Forum Discussion
Parsing a word document into a csv or other machine readable format
Hi all, I have a non-delimited text file of health data called "2014_data.txt". This text file doesn't have any structure to it and the only way to structure it into columns and rows is to use the...
Assuming your Excel is with Power Query, on ribbon Data->From Text/CSV->select your file.
First screen will be as
After that you may click on Transform to make adjustments or Load directly to Excel sheet.