1
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,...)?
Thanks a lot for that quick reply! I will consider reformatting my table as you suggested. I am a bit disappointed the Pivot Table functions don't offer that function right a way. :( – eyeweiss – 2017-02-16T07:21:37.927