Challenge #2: Preparing Delimited Data

[pvercosa]

Hi!

My solution here.

Thanks!

[edgarcvellar]

My workflow 

[jsenk]

Solution

[PetrNguyen]

have a look

[dhavaler]

Official solution was more elegant but this one worked out. 

Spoiler

[FelixLupu]

I am sure there are many ways. This is how I did it.

[VVill_T]

Done - thanks for creating the exercise

[asamudra1312]

Kindly find my working attached.

Whilst I found that the Formula tool is really powerful, I kind of wish that the Text To Columns could split multiple columns at the same time ;D

[nimit16]

Uploaded the solution as pat of practice exercise. 

[KCYoung]

Here is my solution.