Challenge #49: Reformatting Transactional Data

[marcreid]

Solution

Spoiler

[Natasha]

Similar solution, though I used Find and Replace instead of Join.

Spoiler

[LalaLele66]

Another one finished! Normally I would have used the TRIM formula, but with version 11.5, the red/ green bar told me what was wrong, so that prompted me to try the Data Cleansing formula instead. 

[samN]

pretty much the same as the solution. Another one down

[ggruccio]

Several steps to get there - getting great practice with these tools!

[SGolnik]

This one reminds me of the data I get at work LOL

[LandonG]

Solution attached.

[PhilipMannering]

My solution is attached.

Spoiler

[jasperlch]

Solution attached.

[msicak]

Struggled with this longer than I'd like to admit, but got there in the end.

Spoiler