Completed
5 Power Query Solution. Keyboard to import Excel Table into Power Query Editor
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Lookup Manager Names in Column Headers to Create Report - Excel Magic Trick 1866
Automatically move to the next video in the Classroom when playback concludes
- 1 1 Introduction
- 2 2 Worksheet function to create column of employee names from a table using TOCOL and UNIQUE functions.
- 3 3 Worksheet function to lookup manager names and join with a comma between each name using the IF and TEXTJOIN functions.
- 4 4 Links to buy new excelisfun Mike Girvin M Code book
- 5 5 Power Query Solution. Keyboard to import Excel Table into Power Query Editor
- 6 6 UnPivot to create a proper data table
- 7 7 Group By to gather manager names into a table.
- 8 8 Why to remove spaces from identifier names
- 9 9 Edit Table.Group Function to extract a column from a table as a list using the Field Access Operator.
- 10 10 What does M Code syntax Underscore mean?
- 11 11 Text.Combine function
- 12 12 Look at let expression
- 13 13 Summary
- 14 14 Closing and video links
