Subtotal To Include Item Description On Subtotal Line

[Tickfarmer]

I am using the subtotal feature on data listed below. I have requested a
subtotal of item qty at every change in the item number. The subtotal line
will return the item number and the subtotaled qty. This is good. However,
I wold also like the item description to be included on the subtotal line.
How do I accomplish this?

Item Number Item Description Item Qty
RM Red Mug 100
RM Red Mug 25
RM-2 Red Dot Mug 49
RM-2 Red Dot Mug 2

 

[Dave Peterson]

Data|Subtotal won't do this on its own.

I'd insert a helper column in column A and add a formula:

=left(b2&rept(" ",30),30)&"-"&c2
and drag down

Then use that as the control field in the subtotals.

 

[Tickfarmer]

Hi Dave. Thanks so much for the suggestion. With some slight editing of
your formula, I have accomplished my goal. Appreciate your help.