Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,593
    Thanks
    44
    Thanked 77 Times in 72 Posts

    Consolidate Rows and columns

    My best title for this.

    I have a sheet that beginning in row 2, there are blocks of data related to products.

    A2 has a producd name. There are a number of rows (13 and sometimes 14) rows that are associated with product. I need 1 row per product with all of the related information in that row about the product.

    So, in one case I need a row that's consists of:

    A2, B3, C4, D5, ...N15 and in the next row I need
    A16, B17, etc. (but there may not be 14 rows; maybe 13)

    The "key" is when the A column has text versus is blank.

    Any suggestions?
    Last edited by kweaver; 2012-03-18 at 15:54.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    10,003
    Thanks
    423
    Thanked 1,608 Times in 1,452 Posts
    K,

    You'll most likely need VBA to accomplish this. If you could post an example worksheet with maybe 3 or 4 products some with 13 rows and some with 14 rows and then a sheet that shows how the final output should look.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,593
    Thanks
    44
    Thanked 77 Times in 72 Posts
    I think I found a way to resolve this since it's a one-off situation. Used filters and some simple code. Thanks for offering.
    I'll sing out if I didn't accomplish what I need. - Kevin

Posting Permissions

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