Trouble with Pivot Table Dates

[Excelam]

Hi All,

First, I am new to the forum and appreciative of any help that is offered. I have an issue with using a pivot table on data in the format below. The month headers are text in the data set. My goal is to have a pivot table with slicers where the data is summarized with each Month in the first row of the pivot table, the "Request" as a filter or slicer, and the corresponding data for each month and request resulting in the table.

Currently, when I drop the Month in "Rows" section of the Pivot Table Fields, I get a result like below. As an FYI, the data I'm working with has 40 Month columns and approx. 2,500 rows.

Again, thank you for the help!

Data:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Request[/TD]
[TD]Jan-2010[/TD]
[TD]Feb-2010[/TD]
[TD]Mar-2010[/TD]
[TD]Apr-2010[/TD]
[TD]May-2010[/TD]
[TD]Jun-2010[/TD]
[TD]Jul-2010[/TD]
[TD]Aug-2010[/TD]
[/TR]
[TR]
[TD]Option 1[/TD]
[TD]2[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]9[/TD]
[TD]15[/TD]
[TD]9[/TD]
[TD]3[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]Option 1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]10[/TD]
[TD]21[/TD]
[TD]33[/TD]
[TD]42[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Option 2[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]18[/TD]
[TD]27[/TD]
[TD]45[/TD]
[TD]51[/TD]
[/TR]
[TR]
[TD]Option 3[/TD]
[TD]2[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Option 3[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]29[/TD]
[TD]38[/TD]
[TD]39[/TD]
[/TR]
[TR]
[TD]Option 4[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]Option 5[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Option 5[/TD]
[TD]0[/TD]
[TD]9[/TD]
[TD]15[/TD]
[TD]21[/TD]
[TD]21[/TD]
[TD]21[/TD]
[TD]21[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]Option 5[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]15[/TD]
[TD]19[/TD]
[TD]25[/TD]
[TD]27[/TD]
[/TR]
</tbody>[/TABLE]

Current Pivot Table Result:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Row Labels[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]0
[/TD]
[/TR]
[TR]
[TD]0[/TD]
[/TR]
[TR]
[TD]2[/TD]
[/TR]
[TR]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]5[/TD]
[/TR]
[TR]
[TD]0[/TD]
[/TR]
[TR]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[Excelam]

Any ideas?