If I want to to pivot 60 columns, but want to group 6 columns together (so after pivoting there would be 6 columns with 10 rows) is there a way to do that?
I would appreciate any help.
If I want to to pivot 60 columns, but want to group 6 columns together (so after pivoting there would be 6 columns with 10 rows) is there a way to do that?
I would appreciate any help.
Grouping for getting the Grand Total or Grouping for quick navigation?
If your intention is the second one then you can use Column Grouping else the Answer is NO you can't
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Join sample file and show what you want to achieve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks