Challenge #53: Parsing Report Formatted Data

[NicolasSz]

Done :) 

[klturi421]

Here's my take.

[BRRLL99]

Issue has been Resolved using Standard Macro

[carmenrapariz]

Spoiler

[danblythe]

Spoiler

Love that the challenge ask you what if the column number was different :)

[BS_THE_ANALYST]

Nice seems pretty dynamic. I did make the assumption that all #'s will be replaced with N/A. I guess this could be potentially problematic further down the line if a company uses serial numbers... anyhow, this can be amended with a multi-field tool but I tried to go for an automated solution 😂

Spoiler

[alacoume]

My solution:

[kristiadiuisan]

Spoiler

Macro

[Flo_P]

Spoiler

Varying columns should be caught. Only static approach is for the N/A replacement, but that can be added to include all or specific columns.

[leonhekkert]

My solution:

Spoiler