Challenge #53: Parsing Report Formatted Data

[jssandom]

My solution

[kelly_gilbert]

Such a practical challenge... Haven't we all needed to work with data like this at some point or another!

Spoiler

[JoshuaGostick]

My solution. I've added a data quality check in case the Split to Columns tool is not creating enough columns.

Spoiler

[NilsM]

My solution:

Spoiler

[Kenda]

Spoiler

I decided to just rename the field that comes in so that I can work with that in case the number of dashes changes in the future. Then splitting the data into rows instead of columns should account for any instance where the number of given columns or rows changes. 

[jbranaum]

My Solution

[vsoni]

My solution attached! 

[ipeng]

My solution. This is an easy one. 

[mickael_gest]

My solution :)

Spoiler

[JamesMA]

Managed to get the logic fairly quickly, judging the number of necessary columns was the tricky part!

Spoiler