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 cant 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
dont want. And I dont know how to add the comma separators.


Thanks for any help you can provide.