Скачать или смотреть ComputerGagaChallenge 2: Data Normalization and Missing Entries

In the previous video I showed a solution to a problem presented by Alan Murray at ComputerGaga. But Haider Ali asked about missing entries.


(To purchase Excel Insights, here it is: https://www.mrexcel.com/store/index.p...)



The challenge requires data to be converted from jumbled lists and into neat rows. The lists are what people have chosen for an appetizer, dinner and dessert. BUT! What if someone only wants an appetizer and dinner? That adds a serious twist to the solution.
Here, I re-do the solution and include several Power Query moves:

Grasshopper Leg Pluck
String of Pearls
Pile In, Pile Up
They use: left outerjoin, unpivot, split columns into rows, merge columns







For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/ins...


Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analy...

My old blog: http://datascopic.net/blog-2-2