+ Reply to Thread
Results 1 to 2 of 2

Group many columns by row

  1. #1
    Registered User
    Join Date
    09-02-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    4

    Group many columns by row

    Hey all,

    I am totally stuck in creating a VBA code to group lots of rows across different columns. As you can see in the tab "Example Data", I have data in column A1, and as a subset, of A1 data in B2-B3, and as a subset of B3 data in C4-C13, and so on in columns D and E. A new 'header' begins in A15, and again in A16 and again in A17, this shows that not all 'headers' in any column have an equal numbers of subsets (some have 0, some 1, and so on) I need to group each data subset under each 'header' across all the columns. I have manually grouped the data as I intend it to be in "Example Result" so you can see how the subsets are all grouped under their headers. I also show it fully grouped/minimized in the tab "Example Results and Minimized". The actual data set I am working with has a few thousand lines and about 11 columns. I was able to get a code working with JUST data in columns A and B but could not carry it across a 3rd or more columns. Any help would be greatly appreciated!!!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    09-02-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    4

    Re: Group many columns by row

    bumping this up. still cant get it lol

+ 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. Replies: 1
    Last Post: 02-10-2014, 10:26 PM
  2. Replies: 2
    Last Post: 01-18-2013, 12:45 PM
  3. Excel 2007 : How to group 2 columns together
    By newhire in forum Excel General
    Replies: 1
    Last Post: 06-25-2009, 03:36 PM
  4. Sorting groups of columns to a related group of columns
    By fuadramsey in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-15-2007, 07:56 PM
  5. [SOLVED] to convert columns to rows having mulit independent group columns
    By Quacy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2006, 06:25 PM

Tags for this Thread

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