Forum Discussion
Nishkarsh31
Dec 23, 2021Brass Contributor
Is it possible to extract PDF data to excel using Power Query?
I have a website which exports orders in pdf form
I extracted the data, but it's the most scattered query EVER.
Could really use your help in organizing the data
Can you help me out? I've attached the query file and Raw Data
SergeiBaklan Riny_van_Eekelen PeterBartholomew1 HansVogelaar
Nishkarsh31 Not very straight-forward, but you could try something like in the attached file. Similar, tough not the same as your desired output.
3 Replies
- Riny_van_EekelenPlatinum Contributor
Nishkarsh31 Not very straight-forward, but you could try something like in the attached file. Similar, tough not the same as your desired output.
- Nishkarsh31Brass ContributorSir, you're so amazing,
I don't have enough words to express it here.
Forever grateful.
Although I'll take me sweet time to understand the steps to be able to replicate this on my own.
But it's working Perfectly well, on all kind of input data.
This is without a doubt, leakproof.
Thanks again.- Riny_van_EekelenPlatinum Contributor
Nishkarsh31 Great. Let me know if I can explain further.