SOLVED

Summarize from multiple table(s)

New Contributor

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

 

2 Replies
best response confirmed by a4avinash (New Contributor)
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.

 

 

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.