Challenge #2: Preparing Delimited Data

[ds10707]

Solution method way different than the downloaded solution.  

[jguerrero]

My Solution:

[jyojyoti]

Hi,

Here you go

[Vikash_kumar]

Challenge #2 solution attached.

[JKCecil]

Ta da!

[Jodapa]

this works

[JonnyPage]

I'm not sure this is the most elegant solution, but with a bit of experimentation using the Text to Columns tool achieved the correct output.

[WouterWelman]

My Week 2 challenge solution

[izamryan]

I achieved the right end result ... but I think I solved this by brute force instead of the more elegant solutions given.

Spoiler

I specified multiple delimiters in the Text to Columns tool