Need to do this from excel fast. And found the simple solution from here. I copy pasted the question from that superuser here for my own documentation.
I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this:
1234 123461 123151 11321
And make them into a comma-separated list in another cell that the user can easily copy and paste into another program like so:
What is the easiest way to do this?
Assuming your data starts in A1 I would put the following in column B:
You can then paste column B2 down the whole column. The last cell in column B should now be a comma separated list of column A.