Hi All,
I have a text file I'm trying to modify via Power Query.
If I attempt to open the file directly in excel, the Text to Columns wizard appears and correctly identifies the general column structure in the file. However, when I try to import the same file through power query, it lumps everything in a single column making it very difficult to manipulate.
I've attached a sample of the data - any help would be great!
Thanks.
Bookmarks