Challenge #49: Reformatting Transactional Data

[Mattpannuzzo]

My solution.

Uses the formula tool with IF statements to create the three columns after they've been transposed. 

Spoiler

[dsmdavid]

One of the first times I have used the make columns tool...

Spoiler

[Syfer889]

Needed help on this one. Thank you for the many different solutions. Went the popular route.

[luciebrett]

Pretty similar just ended with data cleansing rather than using formula to trim before.

[ponraj]

uploading the solution. 

[mascarenhas_lucas]

Spoiler

[daniel_ferreira]

Follow my solution file attached...

[StevenBetts]

Here's how I solved this this :)

[AndyBate]

Complete

[KOBoyle]

Solution attached.