Using Pivot for Horizontal listed Dates?

[zikews]

Hi,

I'm having difficulty setting up a pivot table for a table I have, where the dates are listed horizontally and the dimensions/metrics are listed vertically. See example:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan-13[/TD]
[TD]Feb-13[/TD]
[TD]March-13[/TD]
[/TR]
[TR]
[TD]Metric1[/TD]
[TD]5[/TD]
[TD]43[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]Metric2[/TD]
[TD]3[/TD]
[TD]2[/TD]
[TD]38[/TD]
[/TR]
</tbody>[/TABLE]

Any way to get this to work so that when I pivot it groups the dates as months? (I also have the same table for weeks/days/quarters. The reason why the dates are listed horizontally is because I need to do variance columns as well which is easier to do in this format.

Thanks in advance!

 

[Fazza]

Yes it is possible, but really it is not what one would do. Better to set the data up properly in single table with 3 fields like metric, date, value

regards

post script : for info on data normalisation (setting up data properly) see articles like http://en.wikipedia.org/wiki/Database_normalization