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.php?l=product_detail&p=381)

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/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

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