ExcelBanter - make 3 columns into rows

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - make 3 columns into rows (https://www.excelbanter.com/excel-discussion-misc-queries/209436-make-3-columns-into-rows.html)

rodchar

make 3 columns into rows

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

Tim879

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

rodchar

make 3 columns into rows

thank you for your help,
rod.

"Tim879" wrote:

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

Stig - tame racing driver

make 3 columns into rows

not sure what you mean........ but try this

Copy - Special paste - and then tick transpose

Hope this helps

"rodchar" wrote in message
...
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

All times are GMT +1. The time now is 05:15 AM.