Challenge #63: Data Preperation Using Pivot Tools

[pawanmalik]

My solution for this challenge.

[Verakso]

Solved this a while back, not sure why I haven't submitted it before, but here it is

Spoiler

Probably got stucked, trying to do some dynamic renaming of the the headers, but ended up doing it manually in the select tool anyway

Still Climbing
/Verakso

[priya-18]

its really Challenge , used Multi-row formula and Dynamic Rename, Transpose and Cross tab tool multiple times.

[wwatson]

my solution

[kevin025]

Here is my solution

[josh_ebg]

My Solution 🙂

Spoiler

[annedione]

Here is my solution

[vinaybhaskar]

My Solution

[ngindam]

Not an elegant solution but gone the work done. 
Will have to understand the solution provided.

There are many new functions included in the solution like Regex Replace.

Spoiler

[KilianL]

Great challenge on how to clean and restructure a table.

Lessons to learn:

1. use of Transpose and Cross-Tab

2. restructuring by e.g. Filter + Join Tool

3. filling in Nulls with the Multi-Row Formula Tool

Spoiler