In this video, we import multiple pages of data from a website with one Excel query using Power Query.
We create a table of URL's that can automatically update on a sheet, import data from the web and then turn it into a function with some M code.
We then create a custom column to use this function and feed it the URLs from the table to import as many pages as we want.
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/2JvnnRv
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
22 июн 2024