Hello,
I'm tracking truck deliveries. I have a dynamic data set. I want to consolidate the data and sum duplicate lines. Below is my example:
<tbody>
</tbody>
I want to sum/count the "Line #" column for duplicate rows. I'm not too worried about deleting duplicate rows as once counted I can clear all duplicates in the data set. I do have a CONCAT code in Column A in order to make referencing easier. Any help is much appreciated!
I'm tracking truck deliveries. I have a dynamic data set. I want to consolidate the data and sum duplicate lines. Below is my example:
CONCAT Code | Delivery Date | Customer | Origin | Destination | Line # | Carrier |
7/6/2017 | Oil Co. | Houston | Dallas | 1 | Energy Transport | |
7/6/2017 | Fuel Ltd. | Oklahoma City | Kansas City | 1 | Tanker Co. | |
7/6/2017 | Oil Co. | Houston | Dallas | 1 | Energy Transport | |
7/6/2017 | Oil Co. | Houston | Dallas | 1 | Fuel Delivery | |
7/6/2017 | Fuel Ltd. | Oklahoma City | Kansas City | 1 | Tanker Co. |
<tbody>
</tbody>
I want to sum/count the "Line #" column for duplicate rows. I'm not too worried about deleting duplicate rows as once counted I can clear all duplicates in the data set. I do have a CONCAT code in Column A in order to make referencing easier. Any help is much appreciated!