Is there a way to rotate info from a range for example:

10 134 - 1205 2.72 CELL1 FALSE FALSE
10 134 - 1402 0.12 CELL1 FALSE FALSE
into a single row where the info from above will display as follow


10 134 - 1205 2.72 CELL1 FALSE FALSE 10 134 - 1402 0.12 CELL1 FALSE FALSE



"LPS" wrote:

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.