Hi,

I'm not sure if this was already answered before here but here's the situation. I have a table which shows this information.

ID Status Month Year
1 R Jan 2013
1 Y Feb 2013
2 G Jan 2013
2 Y Feb 2013
3 G Jan 2013
3 G Feb 2013
1 Y Mar 2013
2 G Mar 2013
3 G Mar 2013

Imaging that i have a data like this for the whole year that has hundreds of IDs. What i want to do is something like a pivot table that would show me the trend of the status an ID, much like a pivot table that shows text.

Status Jan Feb Mar
1 R Y Y
2 G Y G
3 G G G