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!
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
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
Helpful resources
FabCon Global Hackathon
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
