Forum Discussion
Solved
How to extract unstructured data into excel
So I have data taken from a website and want to process it using Excel but I only have a .txt file. Here is the data like this. I've tried using the WRAPPROWS function but that doesn't work. Any sugg...
Challenge is sometimes a Problem record consists of 6 rows, sometimes 7
In attached file a Power Query approach. In the Source step replace the file path (line File.Contents) to the text file with yours:Source = Csv.Document( File.Contents("X:\Abc\Def\ProblemsSample.txt"), [Delimiter="#(lf)", Columns=1, QuoteStyle=QuoteStyle.None] )
Unfortunately I can't access the website, I can only process the data provided in the form of a txt file
Right. Does the sire offer any other formats for exporting perhaps?
JKPieterse Only txt files