Thread: How to transpose and concatenate long list in one column?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CSchwass CSchwass is offline
external usenet poster
  
Posts: 10
Default How to transpose and concatenate long list in one column?
I have a list like this in column A:

2345
1023
1492
2985
2902
etc

....but much longer. I want this result in one cell:

2345,1023,1492,2985,2902,etc

I will continually add to the list in Column A and I don't want to update
the formula every time for the CSV cell.

How can I do this?

Thanks,
Chris
Reply With QuoteReply With Quote