Feb 28 2022 01:20 AM - edited Feb 28 2022 01:21 AM
Hi there!
I'm trying to extract data in a summary file from 12-sheet tables, where each sheet is a month.
The tables I've taken into consideration are from a government GST portal.
The current practice is to create manual links by copying from the required PDF file. However, I converted the PDF file into an Excel file for further processing.
Sample file attached.
https://1drv.ms/x/s!AhfNqwYEWYSHg2uQ4jtTyYkrOE6J?e=MuNO37
Data in separate sheet
MS Office Version 2016
P.S. I would highly appreciate if someone could suggest me whether I can accomplish this task via Power Query Editor
Feb 28 2022 03:22 AM
Solution@a4avinash Oh my goodness! That's not very easy, but if you make sure that the data dump for every month has exactly the same lay-out, you could extract all rows that have amounts in them and create a "somewhat organized" table that should enable you to get the summary you need. See attached file.
Note: I needed to change the lay-out for May as it was not the same is for April. The first two rows where not similar, inserted row 9 and added a par 6.2 at the bottom. Just check and see what I did.
Feb 28 2022 07:39 AM - edited Feb 28 2022 07:55 AM
Thank you, sir Riny_van_Eekelen.
I very much appreciate for giving me your time.
However, I'm afraid that I have reached a dead end to this thread.
Maybe there's not a lot to do about it.
It was my fault; I had converted the PDF to Excel and that, sir, was a cause for all those concerns.
Maybe next time I'll try and figure it out.
Until then...
Bid adieu, monsieur.
Feb 28 2022 03:22 AM
Solution@a4avinash Oh my goodness! That's not very easy, but if you make sure that the data dump for every month has exactly the same lay-out, you could extract all rows that have amounts in them and create a "somewhat organized" table that should enable you to get the summary you need. See attached file.
Note: I needed to change the lay-out for May as it was not the same is for April. The first two rows where not similar, inserted row 9 and added a par 6.2 at the bottom. Just check and see what I did.