Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am working with individual axles within axle groups on transport trucks. Each axle group has up to four individual axles, and each axle is identified individually with an ID number. Each axle has an offset that is represented in a "grouped" layout. I want to change the grouped layout into a single column as shown in the simplified, attached spreadsheet. I did the transformation manually, but need to duplicate the same function with formula. I've tried every combination of MATCH() and VLOOKUP() that I can think of, but no success yet. Can anybody help me solve this? Thanks.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I don't see an attachment yet...

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [attachment=87284:TransposeGroupToColumnar.xls]

    Ooops - overlooked the "Upload File" button.
    Attached Files Attached Files
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Enter this "interesting" formula in B17 and fill down:

    =INDEX($G$9:$J$13,MATCH(A17,$B$9:$B$13,1),MATCH(A1 7,OFFSET($B$8:$E$8,MATCH(A17,$B$9:$B$13,1),0),0))

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, Hans. You've come thru as usual!
    Now I have to dissect that formula into its components so I can deal with the other parts of the worksheet that I did not include in the simplified example.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    It might be easier to use intermediate formulas - here is what I created before merging the formulas into one megaformula.

    [attachment=87285:TransposeGroupToColumnar.xls]
    Attached Files Attached Files

Posting Permissions

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