Challenge #53: Parsing Report Formatted Data

[OllieClarke]

This one was god fun :)

Spoiler

[justynam]

Yes, this one was  good fun:-)

My solution without macros

[Gauthier_B]

Went for the batch macro

Spoiler

[JoBen]

Cheers!

[MarMu]

Didn't use any macros, just a plain workflow.

Used a RecordID and a Multi-Row formula tool to identify rows and columns respectively and a Dynamic Rename to fix headers. Pretty straight forward.

I was caught a bit by surprise by the cleaning steps. So I added a RegEx for replacing empty with N/A. The Crosstab-tool leaves Empty for "missing" record items, so I added a Multi-Field formula for replacing Empty with Null. I actually think that this is the first time I have found a use case for that tool. Kodos.

Spoiler

[Laurap1228]

I probably could have done this in fewer tools.

Spoiler

[pasccout]

Here is my solution... should work up to 500 fields

[kbwissi]

Slightly different solution.