Challenge #3: Running Averages

[raeaton]

Was a bit confused as to what was wanted but here is my solution. Kept it simple. 

Spoiler

[Hannah71]

I must read the hints - that was the hardest bit!

[Hannah71]

and another way

[mattnason1]

It took me way longer than it should have to understand that you had to change the number of rows in the multi-row tool to be allowed to go back more than 1 month.

[jbichachi003]

My solution!

Spoiler

I thought that the answer was strangely presented, so I also added an alternative solution that I think presents the data a bit better.

Challenge 2 solution

[samdarmo]

I don't think my solution is correct and I don't think I understood the challenge. But it was fun to do nevertheless. 

[Diederik_vanderharst]

Not sure who'd want their data structured like this, but hey... to each their gravy.

Voila

Spoiler

 

[mindyzhang99]

There is a typing error in question:

the column should be D.1k instead of p.1k

In the original dataset, there is no column called p.1k

It took me longer time to understand it.

[TonyAndriani]

Reposting under my new user ID.

[binu_acs]

Spoiler