undefined

[ajitkanabar]

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 

[ajitkanabar]

Mulford 2024 Catalogue.pdf

[Omid_Motamedise]

Can you share one of the PDF?

[ajitkanabar]

https://onedrive.live.com/?id=root&cid=1FD0FF447E72EA46