Challenge #28: Formatting Financial Data

[pjdit]

Here is my solution.  a little different than what some of the others have posted.  Fun and challenging.

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

[Kenda]

Spoiler

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

[NurulShi12]

Solution attached

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

[Aster]

Spoiler

I chose to unpivot and pivot the table...other than that nothing quite different.

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

[NilsM]

Spoiler

 My solution...

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

[MarMu]

Fun challenge. It has striking resemblance to challenge #23.

All I needed was to adjust the formulas 🙂

Spoiler

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

[OllieClarke]

started off barking up the wrong tree as I assumed I'd need to pivot. took a step back and realised that was silly

Spoiler

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

[SGolnik]

Automating data cleansing is one of my favorite things to do!

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

[Vinutha]

Solved

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

[jevon]

Spoiler

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