Is there a way using the Data = Subtotal feature to show all columns instead
of just the total?

Ex.

Column A - Account
Column B - Name
Column C - Value
Column D - Funny Word

At each change in Column A, I want to sum Column C. However, I also want
Columns B & D to be shown on the same row instead of those related cells
being blank?

I suppose I could concatenate the columns, subtotal, copy/paste special the
values, and then use the text-to-column feature to split the concatenation,
but that seems to be the long way.

Thanks, Ben