Use Power Query to Combine Excel Sheets into one table - 3 Methods Easy - Hard

Описание к видео Use Power Query to Combine Excel Sheets into one table - 3 Methods Easy - Hard

I show 3 techniques for combining / consolidating the data from an Excel file

00:00 Intro
02:21 Connect to a SharePoint file
03:45 The trick to consolidating dynamically
04:23 Consolidate Tables - Difficulty - Easy
06:21 Consolidate Sheets - Difficulty - Medium
10:50 Using a Custom Function if your data is messier - Difficulty - Hard

Download the files I used
https://aasolutions.sharepoint.com/:f...


Subscribe
https://www.youtube.com/c/Accessanaly...

Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/blog/

Комментарии

Информация по комментариям в разработке