Challenge #142: Life Certainties - Workflows, Death, and Taxes

[EW]

I chose the easy path!  My solution:

Spoiler

[jssandom]

I took the easy route! :)

[pjdit]

Went with the easy way first.. 

Spoiler

[GarthG]

This looks hard-path compliant?

[davewarren]

Went the hard route without using a macro... Because apparently I enjoy pain...

But at least I ended up with a nice art piece! :P

Spoiler

Wish I knew about the Arrange tool before I created my waterfall of Selects...

[iain_sterland]

Nice challenge, so glad we have join, transpose and the multi-tools!

Spoiler

[SeanAdams]

Although I didn't include a piggy-bank icon - solution is similar to NJ's ( @NicoleJohnson ), but did do both an easy and hard solution for the exercise.

Spoiler

Enjoyed the two-macro solution posted by @cgoodman3  - didn't think of using 2 inputs to simplify; and the way that @JoBen used the dynamic select to only pick the first column in iterations

@GarthMiles & @patrick_digan have inspired me to go back and redo with the dynamic replace now - same with @estherb47 and @Joe_Mako  and @ggruccio with the arrange tool.

My solution below:
The simple version

[danilang]

Great challenge!

Thinking outside the Transpose/Join/Crosstab box was fun.  Though I avoided the Find Replace cause I think of it as a join tool now!

Spoiler

Slightly different from most.  Used a batch macro to process the company columns in turn and summed the results

Dan

[pasccout]

Here is my "hard" solution... 

Did not use the mentionned tools

[ch12345]

I'm not quite convinced I did the difficult way quite as intended, but I've also not made much use of the Dynamic Replace tool before!

Spoiler