make 3 columns into rows
copy the data - Edit Paste Special - Transpose
On Nov 7, 9:31*am, rodchar wrote:
hey all,
is there a way to take an x amount of columns and automatically make the rows?
row1col1 row1col2 row1col3
into
row1col1
row2col2
row3col3
thanks,
rodchar
|