matching multiple values to its multiple sums

Copper Contributor

I have multiple values, on the other hand the sums of these values.
the sums have invoice numbers
the values do not have invoice numbers
now
I want to put the invoice numbers in front of the values

 

below is a sample

list of values

invoice valuespo
  69,372.52270
  42,221.06270
  40,057.61270
  23,464.30270
  16,702.90270
  14,395.61270
  12,043.31270
    6,742.81270
    6,687.03270
    6,466.87270
    2,434.49270
    2,225.10270
    2,108.66270
    1,479.48270
    1,299.44270
    1,272.04270
  69,372.52270
  42,221.06270
  40,057.61270
  23,464.30270
  16,702.90270
  14,395.61270
  12,043.31270
    6,742.81270
    6,687.03270
    6,466.87270
    2,434.49270
    2,225.10270
    2,108.66270
    1,479.48270
    1,299.44270
    1,272.04270

 

list of sums

 Invoice Total PO Invoice number
           248,973.23270399
           248,973.23270405

 

I hope I get help

0 Replies