Load | Order |
12345 | ABC123 |
23456 | ABC000 |
34567 | ABC000 |
45678 | XYZ123 |
<tbody>
</tbody>
Hi everyone. I'm looking for an easy way to create a new couple of columns with the Distinct order # and next to it the total number of Loads. See example above and then the expected output below. Anyone know??
Load Order Distinct Order Number of Loads
12345 ABC123 ABC123 1
23456 ABC000 ABC000 2
34567 ABC000 XYZ123 1
45678 XYZ123