I have a list of item numbers, descriptions, quantity sold and few other
fields. Data looks like this

Item Description unit Cost Quantity
123 Rubberband LB 1.00 2
123 Rubberband LB 1.00 4
123 Rubberband LB 1.00 2
124 Note pad Ea 1.50 1
124 Note pad EA 1.50 3

When I sort by Item number and subtotal I get

123 Rubber band LB 1.00 2
123 Rubberband LB 1.00 4
123 Rubberband LB 1.00 2
123 Total 8
124 Note pad Ea 1.50 1
124 Note pad EA 1.50 3
124 Total 4

When I collapse it to subtotals only I get
123 Total 8
124 Total 4

Is there any way to include the description on the subtotal line?

gls858