I am trying to create an Excel pivot table. I've got the following simplified table:
I want to create a pivot table looking as follows:
However, after experimenting with the pivot functions, I don't seem to be able to produce such a table. How do I accomplish this using Excel pivot table features (rows, columns, values,...)?