Pivot Table - best way to format

[Sianny2164]

Hi,

I work in marketing and am struggling with being able to do a pivot table due to the large number of fields and different titles. However l know what l want my end point to be. I have streams of data like the below and am basically wanting to be able to set thresholds to form the business rules for an email framework.

I want to be able to see it on a graph that a bunch of contributors have earned between £100-£200 in this month and £200-£500. Can anyone help? Am l looking at it the wrong way?

[TABLE="width: 1289"]
<colgroup><col><col span="12"></colgroup><tbody>[TR]
[TD]Contributor[/TD]
[TD="align: right"]Nov-13[/TD]
[TD="align: right"]Dec-13[/TD]
[TD="align: right"]Jan-14[/TD]
[TD="align: right"]Feb-14[/TD]
[TD="align: right"]Mar-14[/TD]
[TD="align: right"]Apr-14[/TD]
[TD="align: right"]May-14[/TD]
[TD="align: right"]Jun-14[/TD]
[TD="align: right"]Jul-14[/TD]
[TD="align: right"]Aug-14[/TD]
[TD="align: right"]Sep-14[/TD]
[TD="align: right"]Oct-14[/TD]
[/TR]
[TR]
[TD]Contributor 1[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£180.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£110.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£43.05[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£11.16[/TD]
[/TR]
[TR]
[TD]Contributor 2[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[/TR]
[TR]
[TD]Contributor 3[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[TD="align: right"]£0.00[/TD]
[/TR]
</tbody>[/TABLE]