How to rotate records

I have two columns (A and B) in a table:

column_A   开发者_运维知识库   column_B
   10           alb
   13           clk
   22           mbr

I am looking for a solution which would return:

column_A        10      13     22
column_B        alb     clk    mbr

How can I achieve this?

I don't know the number of source rows - it will change dynamically.

---

Try the "Pivot tables" section of this web page: http://www.artfulsoftware.com/infotree/queries.php