Excel 101 - Combine Multiple Files From Folders Using Power Query
Imagine a scenario where you’re tasked with analysing sales data for the prior two years, but you’ve been given the information in 24 separate Excel documents. What do you do? This is where Power Query comes to the rescue.
Read the piece