+ Reply to Thread
Results 1 to 3 of 3

Pivoting table with grouped columns

  1. #1
    Registered User
    Join Date
    12-09-2015
    Location
    Grand Rapids, MI
    MS-Off Ver
    2013
    Posts
    3

    Post Pivoting table with grouped columns

    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.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Pivoting table with grouped columns

    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

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Pivoting table with grouped columns

    Join sample file and show what you want to achieve

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. delete three columns of two grouped columns according to common value of two column
    By shahram_pc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2015, 07:33 PM
  2. Updating two grouped of columns according to one common columns
    By shahram_pc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2015, 06:50 PM
  3. Replies: 8
    Last Post: 01-15-2014, 02:38 AM
  4. Replies: 2
    Last Post: 01-10-2014, 09:30 PM
  5. Replies: 3
    Last Post: 01-07-2014, 06:13 AM
  6. Fill down grouped columns in Pivot Table
    By kmlloyd in forum Excel General
    Replies: 2
    Last Post: 11-05-2010, 09:59 AM
  7. Replies: 1
    Last Post: 02-27-2009, 03:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1