Consolidating lots of individual items

[Edwards80]

Hi folks

I have lurked here for a while and there is some awesome help here. Finally been prompted to post though!

I have a large amount of info that I would like to break down into a more useful summary. The data is basically a list of clients names with a commission amount and a commission type.

I would like to show the info by client and by commission type - at the moment every individual item is listed (Please see the attached example and sample result sheets). I have scanned around but can't find a quick way of doing this - and I don't fancy doing it manually!

Any advice would be very gratefully recieved!

[Shijesh Kumar]

U can use Pivot table to summarize ur data..

See the attachment.

[Edwards80]

<facepalm> - I am very tired and I think I overcomplicated the matter in my head. Many Thanks...