core.noscript.text
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
Thanks, great excercise!
Attached is my answer for Challenge 3.
I didn't know what to do.
This one was tricky, originally tried to do the rolling avgs before the first transpose, once i saw you had to do it after everything fell into place
I can't insert my screenshot so my file is below. I was actually very confused by the format of the given answer so what I came up with looks completely different.
It doesn't look like the output file, but I think the numbers are correct. Followed the instructions instead of duplicating the provided solution.
My solution, it seems the same even with a different final structure
Solved this using 'Multi-Row Formula' twice.
Solution