Challenge #53: Parsing Report Formatted Data

[estherb47]

Amazing variety of solutions!! I went without macros

Spoiler

Spoiler
Slightly different approach. To add a Header ID field to be used in crosstab, I used Smart Tile. Also used a Multi Field formula tool to clean up the text columns that had empty values or # (replace with N/A)

[LordNeilLord]

Solution:

Spoiler

[Natasha]

Similar to others without macro

Spoiler

[nick_ceneviva]

Solution attached

[patrick_digan]

Spoiler

[samN]

Thought i should actually use some other widgets so i challenged myself to not use regex this time... I succeeded but am going back to it the next challenge i get. 

[ggruccio]

Regex tools made this one quick!

[LandonG]

Solution attached.

[PhilipMannering]

Kept my workflow quite simple. Solution attached.

Spoiler

[jasperlch]

Solution attached,