You can try using the Edit | Paste Sepcial |Transpose featu

1. Select and copy the data you want to transpose
2. Position the cell pointer in the first destination cell
3. Select Edit | Paste Special | Transpose

What was a column should now be a row and vice versa.

Cheers,
--
LPS


"Marcus Ricci" wrote:

Is there a way - without using PivotTable - to rotate data in an Excel table:
rows become columns and columns become rows? I wouldn't mind cutting and
pasting, or macros, or anything else.