One way, dynamically
Assuming col data running in A1 down
In B1: =INDEX($A:$A,COLUMNS($A:A))
Copy across as far* as required
*This is limited by the max no. of cols available in your excel ver, of
course
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"jkarennj" wrote:
How do I take data in a column and transfer it to a row format instead? I
don't want to copy/paste every cell. Thanks guys!