Challenge #53: Parsing Report Formatted Data

[jjrbondoc]

Spoiler

[Erin]

Spoiler

I wanted to go a split to rows route in case additional columns are added depending on the data set. This was an added challenge, but I think this solution is pretty dynamic. Only hardcoded pieces are that the spacer rows start with '-----' and the deliminter is '|'. 

[MichelleL]

No macro needed, yet still dynamic.

[BenFr]

I got very stubborn and refused to use a macro...that was a lot of fun!

Spoiler

[LiuZhang]

Spoiler

Tried with a macro to be more dynamic

[CandiceDB]

My solution:

Spoiler

[EdoardoAversaTIL]

Spoiler

 

 

[BSilverblatt]

Thanks for the challenge! Here is my solution:

[r_manju02]

Here is my solution

[davidhardister]