currently have this data the i need to display in a pivot table. losing my mind where to drag those columns in order to achieve the expected output.
If not possible could you recommend other ways to pivot them in a way that is much more understandable.
raw data
expected output
