Text data - M code requested

Power Query
1

Hi ,

I need to create PBI file using data from attached .txt achieve this view below :

image
image708×416 17.9 KB

sample - dui .txt (886 Bytes)

It should look like below in Power Query:

image
image1578×128 3.67 KB

DUI - example .csv (1.5 KB)

DUI - example.csv - I created to show how it should look like in PBI
Lines starting with “V” are crossed off and I don’t need them.

Could you please help me to find appropriate and correct steps ( M code)to complete this task. My original is made up of hundreds of paragraphs like 4 ones above in screenshot.

This is something similar to my request , however I am unable to get correct result: Complex data from txt file into power query - help requested
Many thanks in advance - Iwona

2

Hi @Iwona,

Give this a go, the basics remain unchanged. Just added a count to determine the num of columns.
sample - dui.pbix (104.6 KB)

I hope this is helpful

3

This one step has changed everything.

Many thanks @Melissa for your help and support. This is exactly what I need to use in my job.

Iwona