Challenge #23: Parsing CPG Data

[nick_ceneviva]

Solution attached.  Great challenge

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[patrick_digan]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Natasha]

We did something similar during our Data School training

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[JoshKushner]

Holey Moley this took an hour. Very satisfied with the clean result.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[dsmdavid]

Challenging: usually, what takes longer for me is to visualize the steps in my mind. This time I had the idea in my mind, but found quite challenging to find the proper tools and order to get it done.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[samN]

Spent a fair amount of time trying to make an iterative macro to loop through columns and then realized i was over complicating it.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Waynemk]

and another

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ggruccio]

This one felt like it should have been easier...but had to really think it thru....maybe I took the long road to get there.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[LandonG]

My solution.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[PhilipMannering]

Phew! This was a long one. Solution attached.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.