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:

Request	Jan-2010	Feb-2010	Mar-2010	Apr-2010	May-2010	Jun-2010	Jul-2010	Aug-2010
Option 1	2	7	5	9	15	9	3	17
Option 1	0	0	0	10	21	33	42	5
Option 2	0	0	0	0	18	27	45	51
Option 3	2	5	7	9	15	21	0	0
Option 3	0	0	0	15	21	29	38	39
Option 4	1	2	3	4	10	15	21	25
Option 5	5	3	2	1	1	3	4	7
Option 5	0	9	15	21	21	21	21	21
Option 5	1	3	7	9	15	19	25	27

<tbody>
</tbody>

Current Pivot Table Result:

Row Labels
2
0
0
2
0
1
5
0
1

<tbody>
</tbody>

 

[Excelam]

Any ideas?