I want to show the "values as rows" on the left side of my pivot table on "rows" on the right.

In other words, I want my pivot table rows to be grouped by value rows instead of regular rows.

Current situation:

enter image description here

So, essentially, what I'd like to achieve here is to switch the places for "Channel" and "Values" to get something like this:

enter image description here

Is there any way to build this using a pivot table?


  • Change your google account locale to arabic – Oleg_S Mar 24 at 13:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.