How to show carton no. this way in a report?

[DANIEL SING]

Dear all,
I have a list of shipment every week.
Same items were packed in different cartons.

Carton	Item	Qty
1	A	50
2	A	50
3	A	50
4	A	50
5	B	20
5	A	5
6	C	30
7	A	50

Is it possible to show the list in a report like below?

Carton	Item	Qty
1-4,7	A	50
5	A	5
5	B	20
6	C	30

Above is only a sample, everytime I need to handle over 300 items.
I really need your help.


Thanks a lot.
Daniel

[June7]

You want to concatenate record values where Item and Qty are the same.

Review http://allenbrowne.com/func-concat.html