Challenge #2: Preparing Delimited Data

[Sebastian_Chaieb2]

Just used 'Text to columns' and 'Formula tool to pars the data in appropriate shape and format :)

Spoiler

[adriantanjy]

Interesting challenge!

[MilneJames]

Here's my solution!

[Suzu]

Here is my solution. 

[oswinhull]

Here is my solution.

[lcrutch001]

Another one down.

[roblen]

Done. Probably not the best way to do it, but works fine.

[AK3]

my submitted solution.

[datamonkey]

Used the multi-field formula rather than multiple individual formulae to trim any single/double quotation marks at the beginning and end of each field