So this challenge was another intermediate challenge. Unpivot was the main trick to get the data lined up and I walk you through that in the video.

One thing to note is that a lot of times conceptually it may be easier to break up your tables and solve issues in a set-by-step fashion. This is completely fine and a lot of times anyone checking your work will thank you for it!

In this demo, I broke up online versus mobile into separate tables, then once I had the unpivots done I merged them back and kept going. This was the quickest way I could think of getting the data lined up the way I needed it, but again, with data prep there are usually multiple ways of doing things.

Hope you enjoy!