Mr. Excel (Bill Jelen) Challenge | Flattening Crazy Data | Podcast 2316

Mr. Excel, Bill Jelen, was presented with a challenge where someone's data was twisted in a weird sort of way and needed to be untwisted; e.g. the data needed to be flattened.

Here is the challenge: https://youtu.be/S9ow-1Jq_rE

Bill asked for other solutions than his own. Here's mine. This is one of those examples where it helped me most to bring the data into Power Query and then Transpose it. This may not have been the most efficient solution. However, after the Transpose, I could see a clear bath to the end.

The solution involves:
- Transpose
- Unpivot
- Pivot
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: http://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

Видео Mr. Excel (Bill Jelen) Challenge | Flattening Crazy Data | Podcast 2316 канала Excel On Fire