Repeat Columns in my Power Query Append?? Too Many Columns? Extra Columns? EMT 1623

Download Start Excel File: Download Finished Excel File:
Learn all about what causes extra unwanted columns in a Power Query Append, and a few other Power Query Tricks
1. (00:01) Introduction
2. (00:37) Inconsistent Field Names will not be appended correctly
3. (00:56) Columns with Consistent Field Names that are in a different Order will Append Correctly
4. (01:30) Hack to get Excel.CurrentWorkbook function to get all tables in a workbook file.
5. (03:05) Look at problem in Power Query with Inconsistent Field Names.
6. (04:30) Close and Load as Connection.
7. (04:35) Manually Fix Field Names
8. (05:35) Finish Append Query with correct Field Names.
9. (06:07) Reorder Columns with Remove Other Column feature
10. (07:17) Load to PivotTable Cache.
11. (07:31) Build PivotTable Report from a PivotTable Cache
12. (07:37) Summary

Excel,Highline College,Mike Girvin,excelisfun,excel is fun,EMT,EMT 1622,Excel Magic Trick 1622,Extra Columns in my Power Query Append,How come I get Extra Column in Power Query Append,My Append has too many Columns,Power Query Append Error,Power Query Column has null values,Repeat Column in Append,How to fix append with too many columns,Power Query Append,EMT 1623,Excel Magic Trick 1623,