Hi, can anyone help me with this in Power Query? I'm trying to get data like this first table (Table 1) to look like (Table 2).
I understand how to unpivot and pivot in Power Query (and it doesn't work here - I get an error with Sally's hobby)
What I don't understand is how to go through and...