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] )
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]
)
Thank you for your help, it is very helpful