Importing Multiple Tables From A Webpage To A Single Sheet

[abhinav28]

Hi

I am trying to import tables from this webpage, Section 2:Call Charges & Exchange Line Services Part 13:National and International Number Group Codes Used for Specialised Services - 08xx Numbers Subpart 1:Call Charges, and I was successful in doing so by using the 'get data > from web' tool but the tables were spread out in separate sheets. And I would like to have all of them in one sheet. So I wanted to ask if anyone in mrexcel knew how to do this.

Kind regards,

Abhinav

 

[sandy666]

maybe try to read

Power Query documentation - Power Query

Power Query is used to filter, combine, and mash up data from one or more supported data sources.

docs.microsoft.com

 

[abhinav28]

Hi Sandy,

Thank you for directing me to that page. It has helped me a little and have been able to combine the tables into one sheet with the help from your source and other sources as well.

And I think I need more training on power queries. Do you mind telling me a good place to start learning power queries?

Thank you,

Abhinav

 

[sandy666]

there are a lot of movies on youtube, books you can buy, forums you can read
I usually use the link I posted in post#2 (I started with this link and so far use it as a base, to be honest I only use this one)
Tests, tests and tests again
I never used any PQ course

 

[abhinav28]

Thank you Sandy

 

[sandy666]

You are welcome, happy querying