subtotal row data in other columns

S

shcr

I have a worksheet:

A = $ value
B = Title of work
C = Another number tied to B.

When I subtotal on column B, and have the subtotal for column A, I also
want the value in Column C to appear. When I click on the collapse I want
to see Column C as it provides more information and helps to decipher what
Column B is.

TIA
 
Top