Data from one column is displaced in 2 columns - how to merge the data correctly

[MsArtaLa]

Hi all

I'm new to Power Query and have been struggling with some issue. I'm getting data from pdf files but when data is in Query - each column is displaced - please see below:

How to achieve that relevant data is in the right column?

And if pdf document is on 3 pages - then data from one column can be displaced in 3 columns - on each page on different column.

Thank you in advance for any suggestion!

[v-cgao-msft · Accepted solution]

Hi @MsArtaLa ,

The way I can think of is to manually filter out the tables and then append them together.

Add a index column first.

Filter tables:

Append tables:

Remove unwanted columns:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum