Challenge #63: Data Preperation Using Pivot Tools

[ArtApa]

This is a good one. Here is my solution:

Spoiler

[KieranAdair]

Completed

[Ajjay]

Spoiler

Less complicated

[jjrbondoc]

Spoiler

[zackli]

Great practice! It's mind-blowing looking at some of the different solutions here.

My solution takes a divide-and-conquer approach before assembling the data with a Join Multiple for a Cross Tab. It's marvelous to see how you guys pivot the whole thing and work on it that way.

Spoiler

[KeerthanaKarthikeyan]

Data Preperation Using Pivot Tools

[jcasto]

Done! Challenge was very helpful for me to learn the Dynamic Rename tool and RegEx syntax. 

[jcasto]

I like that you used the Select Records tool right away! Did not think to use that and it would have made it a lot easier for me lol.

[ExploreMore]

Spoiler

 

[shayanpanjwani]

Here's my solution!

Spoiler