Results 1 to 2 of 2

Thread: Need to Combine Rows
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2014
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need to Combine Rows

    In the spreadsheet below I have information that represents truckloads of steel. The different colors represent one individual load that has multiple shipper cities and / or multiple receiver cities. The loads however are on different Lines. They are identified by a unique Load ID (column B). The Blue Lines represent a load that had 2 different pickup cities and 2 different receiver cities.

    What I want to capture is the amount of times each load combination happened. For example below we have 4 different loads. Load ID 1023765 is Shipper 1 Madison, Shipper 2 Red Bud, Receiver 1 Paris, Receiver 2 Flora.


    Can anyone give me some help?

    Thanks.

    A B C D G I J
    Transport Order ID
    Load ID
    Shipper
    Shipper City
    Receiver City
    Gross Weight [lb] (Load)
    Gross Weight [lb] (TO)
    10331622 1023765
    Custom Steel
    Madison Paris 44470 24280
    10331624 1023765 Custom Steel Red Bud Flora 44470 20190
    10333000 1025493 Custom Steel Madison Paris 46734 15212
    10333002 1025493 Custom Steel Red Bud Paris 46734 31522
    10333009 1025498 Custom Steel Madison Flora 45980 38710
    1033010 1025498 Custom Steel Red Bud Paris 45980 7270
    1033623 1026131 Custom Steel Red Bud Paris 43211 39632
    1033624 1026131 Custom Steel Red Bud Flora 43211 3579

    ****** id="cke_pastebin" style="position: absolute; top: 249px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
    Custom Steel

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,659
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Need to Combine Rows

    For the table you posted, what would be the complete desired output?
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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