Thanks for watching 😊
Working file is available here:
https://drive.google.com/drive/folders/1z16vJ0fpN-JQHj_5ljRc7WLBMI50aXcn?usp=sharing
#MSExcel #PowerQuery #AlejandraHorvath #PowerQueryGirl #Empowered2XL #CustomFunction #KeepSingleValue
0:00 - Overview of dynamic customer name insertion and table transformation
0:23 - Importing data from Excel into Power Query
1:12 - Transforming data and removing unnecessary steps
2:11 - Extracting customer name dynamically
3:34 - Adding customer name column and promoting headers
5:09 - Unpivoting data from January to December
6:31 - Renaming columns for clarity
7:04 - Creating a custom function for transformation
9:02 - Applying the custom function to all sheets
12:23 - Combining all transformed tables
13:17 - Finalizing and loading data into a pivot table
14:30 - Formatting pivot table and final adjustments
Note: Timestamps generated by #ChatGPT
