Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,468
    Thanks
    30
    Thanked 61 Times in 57 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 16:54.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 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,468
    Thanks
    30
    Thanked 61 Times in 57 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
  •