Redux: Students, Courses, Power Query, Group By & Lists

In my previous video I showed a solution to transforming data.
We started with students and the courses they took, and converted that to a view that shows, by course, which student took each one.

That video showed a one-and-done solution. It wasn’t dynamic; i.e., new students or courses would net be integrated.

In this video, I show how a violent mob came after me with brooms and things. They wanted a dynamic solution … and here it is!

This video shows how to use Group By in Power Query, and then add a Custom Column to extract data from a collapsed table through use of a list. We use the function: Table.Column

Then I demonstrated that the solution is indeed dynamic. And I close with a Thank You to all the people who’ve been supportive, challenging, and genuinely interested in keeping this world’s data clean.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2