convert rows to columns in access

[hanyellia]

i have report like that

Evaluation---- year
good ---- 2010
v good ---- 2011
excellent ---- 2012

and i and need one like

2010 ---- 2011 ---- 2012
good ---- v good---- excellent

thanks

 

[hanyellia]

Consider using a pivot table / query