Hi

not sure if it fits the description of not too complex and doesn't work by
dragging, but there is a transpose function
say you have
.........A..........B
1.....Cat........10
2.....Dog.......15
3....Rat..........20

and you want to transpose this table to the range A5:C6
select A5:C6
type
=TRANSPOSE(A1:B3)
and then press Control & Shift & Enter - not just Enter and the data will be
transposed.

Cheers
JulieD

"markx" wrote in message
...
Hello everybody,

I'm looking for a formula (not VBA nor "Paste Special/Transpose") that
would
transpose columns to rows (or vice versa) by simple dragging of the cell.
Are you aware of any, hopefully not too complex?

Thanks a lot for your help on this,
Mark