In SQL can I convert column to rows?

specifically in MS ACCESS, exist a command o function as pivot unpivot work? in these case how can i do to convert using st开发者_StackOverflowandar SQL...

In Access, the simplest way is to use a crosstab query. There is a wizard, but please ask if you need more information.