Transfer data in columns to rows

[PE]

Is it possible to transfer data in columns to rows?

 

[Dave F]

Look at the TRANSPOSE function.
More info here: http://www.techonthenet.com/excel/formulas/transpose.php

Dave

 

[Evan]

Copy > Paste Special > [x] Transpose