Hey,

My name is Sven and I'm currently struggling with the following problem:
I have a table based on transportnumbers who sometimes have doubles.
Example:

Number Postcode Value1 Value 2...
106200 8500 10
106200 8500 5
106200 8600 6
106201 5500 4
106202 4000 1
106202 4000 1

So it works as following: A transportnumber can have multiple instances of itself, such as 106200. This transportnumber can also have multiple instances where the postcode is the same. These are the rows i want to combine
So shortly:
Transportnumber double/triple...+ Postcode double/triple...= combine these rows.
if only transportnumber is double, or only postcode, then dont combine.
I want it to combine 2 colums of values, one will b the kgs, other one a price.

So example of end result for 106200 would be
106200 8500 value+value (these 2 rows matched so it combined the 2 values i want it to)
106200 8600 value ( this was unique so it stays unique)

I hope i explained this well, looking forward to any input

Rgds, Sven