Pivot Table Troubles

[Stripe]

Hello, if anyone can help me with this I'd be most grateful.

I have a set of data which is of this format:

Sector1 Stage1 Value£
Sector1 Stage2 Value£
Sector2 Stage1 Value£
Sector2 Stage1 Value£
Sector3 Stage2 Value£
Sector3 Stage2 Value£

Where Sector and Stage are words and Value£ is a pound figure

And I would really like to show it in a table with the following headings:

Sector; Stagex; number of occurances of stagex; Total Value per Stagex

so that each sector and stage are written only once.

i.e.

Sector1 Stage1 1 Value £
(blank) Stage2 1 Value £
Sector2 Stage 1 2 Value £
Sector3 Stage 2 2 Value £

I've tried everything nothing will work at all.

Any suggestions would be most appreciated. Thank you

 

[Stripe]

Thank you so much! That worked a treat - you're an absolute lifesafer.

If there's anything I can do to help you out at any stage, please PM me.

Thanks so much again.

Alex