Challenge #63: Data Preperation Using Pivot Tools

[simon_inviso]

My solution (Spoiler)

[dbiondo]

.

[jacekDziuba]

My solution 

[MichelleL]

I like the pivot practice, thanks!

[BenFr]

Good pivot practise!

Spoiler

[DanTh]

I never feel I'm being efficient with these particular challenges.

Spoiler

So splitting the headers from data is pretty standard, and then a handy Multi-Row/ Formula combo to manage the missing values. 

3/5

[allwynthomas24]

Spoiler

[ahmedirfanp]

My Submission for the above. I took a bit rounabout approach but it works 😊

[Favian1]

My Solution 

[Erin]

Here's my solution.