\x doesn't exactly rotate it either. \x puts the column headers down the side instead of across the top, but it doesn't put the rows across the top instead of down the side. Rather, each row is listed in a separate chunk.
true, it is rotation per one row. I was wrong.
This feature is doing something else again. I've actually never seen this particular transformation anywhere except for Microsoft Excel's pivot tables, which I still find confusing.