Query - Sub-totalling in Excel

Kewreeuss

HI,
Does anyone have a quick way of doing this(below) instead of copying and pasting all the way:
For example a table with say t columns and 100 lines. every 10 lines one of the columns changes type and one of the other columns has the value and the other columns have information that changes too.
I only want to sum the value column at every change in a particular column, which is fine and then collapse it, which is fine-I can do it.
What I want to do is bring down the detail of the other columns in the line before the subtotal line.
At the moment I expand the table again and copy and paste the line above the subtotal into the line of the subtotal. If you see what I mean.

Imagine a table that has
Car Make, Car Model, CC and value , sorted by Car Make and CC
Then I subtotal the value at every change in CC.
If I collapse it I see CC Total and the value.
But I want to see, on that same line, also the Make. To get this I have to expand again and copy and paste it in from the line above
Is there a way to pull it in as part of the subtotalling process?
Thanks

Taltos

Simplest and fastest way to do this is using our old friend the pivot table - I know it can be a bit daunting at first but without knowing the CC cats you want to break out by this is the most straightforward.

Kewreeuss

I eventually got it sorted.
Pivot tables... I am used to subtotalling-i think it;s a question of habit.
I will have to practice them more, but thank you for replying