V
Villy
I need some help with Excel. I have a worksheet with over 1,000 rows. I
want to copy one column, which contains a value format like “1234-567â€, and
transpose the values to a row. I can’t use the traditional ‘copy-and-paste
special – transpose’ because there are too many cells across. Once I have a
row, I need to make it into one long string where each value is separated by
commas. Does anyone know how to do this?
I tried to transpose my column in chunks, into rows, and then copying into
Word, but Word brings over the borders so it displays as a table – which I
don’t want. And I don’t know how to add the comma separators.
Thanks for any help you can provide.
want to copy one column, which contains a value format like “1234-567â€, and
transpose the values to a row. I can’t use the traditional ‘copy-and-paste
special – transpose’ because there are too many cells across. Once I have a
row, I need to make it into one long string where each value is separated by
commas. Does anyone know how to do this?
I tried to transpose my column in chunks, into rows, and then copying into
Word, but Word brings over the borders so it displays as a table – which I
don’t want. And I don’t know how to add the comma separators.
Thanks for any help you can provide.