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
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
Re: Switching rows and columns in access
copy the first column and paste in some where on the new sheet and use pastespecial values ticked and transpose ticked and enter you will get what you want...
Re: Switching rows and columns in access
http://%22http//www.ozgrid.com/forum/member.php?u=238500&%22 thanks ashu1990
in access
Re: Switching rows and columns in access
Consider using a pivot table / query
Don’t have an account yet? Register yourself now and be a part of our community!