Hi
I need some help with PDF to Power Query.
i have plenty of pdf price tables and they are scattered all over the place and i am trying to make them all in a simple tabular format out of it.
5 columns
Col.A Product Description (Manually added Col.)
Col.B Colour
Col.C Thickness
Col.D Attributes - (After unpivoting other columns) I get from converting rows to columns.
Col.E Value (Prices)
| Product Description | Colour | Thickness | Attribute | Value |
| Cast Acrylic Clear and Opal | Clear | 2.0 mm | 2440 x 1220 | 41 |
| Cast Acrylic Clear and Opal | Clear | 3.0 mm | 2440 x 1220 | 55 |
| Cast Acrylic Clear and Opal | Clear | 3.0 mm | 2440 x 1530 | 70.45 |
| Cast Acrylic Clear and Opal | Clear | 3.0 mm | 2490 x 1880 | 87.5 |
the most interesting part is when i progress doing table7. which has got three rows of headers with those attributes splitted in to two different rows as headers and then i have the prices underneath
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 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.
