Download Excel START Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-StartFilePowerQueryMergeAppendUnPivot.xlsx
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-dSalesRepTable.xlsx
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-dTerritoryTable.txt
Download Excel FINISHED Files:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-FinishedFilePowerQueryMergeAppendUnPivot.xlsx
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-PowerQueryImportCurrentWorkbook.pdf
Assigned Homework:
Download Excel File with Homework:
Assigned Homework:
Download Excel File with Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-Homework-Start.xlsx
Download Files to import for Merge Homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-HomeworkExcelSalesTable.xlsx
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-HomeworkTextdProductTable.txt
Example of Finished Homework:
https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/006-MSPTDA-Homework-Finished.xlsx

In this Video learn about three important Power Query Transformations: Merge, Append and UnPivot.
Topics:
1. (00:15) Introduction.
2. (02:00) Example1: Merge 2 Tables to Replace VLOOKUP or Relationship
3. (08:11) Example 2: Transform 3 Non-Uniform Sales Tables Then Append into Single Proper Data Set
4. (16:31) Example 3: UnPivot to Convert Cross Tabulated Data Tables into Proper Data Set
5. (22:29) Summary

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!