How To Dynamically Keep a Single Value Using Power Query - Bonus: Create a Custom Function!

Опубликовано: 25 Февраль 2024
на канале: Alejandra Horvath

2,999

179

Thanks for watching 😊

Working file is available here:
https://drive.google.com/drive/folder...

#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