Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was harder than I expected. Any time I have to cross tab and transpose there is a lot of trial and error to get it right.
I first just removed the first 3 rows and manually configure the table. After I got that to work I went to generating the lookup table from the data.
Here is my solution!