Dear Team: I have been trying to use a power query to import data from an online database into Excel using a power query. The method I have used is entering the website name into a txt file, hitting enter 5 times and saving, then running the web query through Excel. This has been working. (https://www.youtube.com/watch?v=Kyps7tI7OnU&t=39s)
However, The database is split onto multiple pages. Using the txt file, how should I lay out the different URL's so the Power Query can import all the information to one sheet? Or is there any other way i can import this data? Note: I am using Microsoft Excel for Mac version 16.34.
