How to make a table of multiple XML queries

Hello, I am trying to extract multiple XML responses to a single table. Here is what I'm trying to do:
XML data source looks like > https://example.com/xml/query1
This returns a few columns of data relevant to the query: "query1"
I want to have a list of queries: query1, query-beta, query3, etc. and merge the results in the same table.
I have Excel 2016, but I've only been able to add a query with multiple sources which I can then append to each-other manually.
Can you help with a method of creating a single query to https://example.com/xml/* that then adds the different query values from our list and outputs them together in a single table?

bump maybe?

Originally Posted by teylyn

Hello,

with Excel 2016, you should look into Get & Transform, previously known as Power Query. It supports queries from an xml file and you can combine several queries into one.

cheers, teylyn

Thanks for the response, teylyn. However, adding a query with Get & Transform only offers the option to enter one 'source'. I was able to add multiple ones manually and combine them by hand, but if I have a list of xml 'sources' (especially one that changes), I can't manipulate them all by hand.
It's a shame that Google Sheets' ImportXML offers such powerful functionality and Excel, which is supposed to be a better and more mature product, doesn't seem to have a similar feature.