Hi, I have a problem of matching data with different rows or records ??
Eg.
CUSPO PRTNO ITDSC ORQTY
550927V 292500-00802S MOTOR ASSY, BLOWER 200
551111K 292500-00802S MOTOR ASSY, BLOWER 80
551330K 292500-00802S MOTOR ASSY, BLOWER 80
551331K 292500-00802S MOTOR ASSY, BLOWER 80

s/no PRTNO SHDQY
1 292500-00802S 100
2 292500-00802S 100
3 292500-00802S 40
4 292500-00802S 40
5 292500-00802S 20
6 292500-00802S 30
7 292500-00802S 30
8 292500-00802S 10
9 292500-00802S 40
10 292500-00802S 30

as above are the customer order data and delivery sales data.

any ideas how to do matching ???

Thanks.
--
llm