I have column A which has
1234
123461
123151
11321
(note that the rows are dynamic. it is 4 but can be more)
I need to change the values in column A and make them into a comma-separated list in another cell that the user can easily copy and paste into another program. It should be like this:-
1234,123461,123151,11321
What is the quickest way to do it ? Formulas ? I tried paste special transpose but cannot achieve it ? I can do it in macro but wondering if there are other simple ways to do it.
Any help?
1234
123461
123151
11321
(note that the rows are dynamic. it is 4 but can be more)
I need to change the values in column A and make them into a comma-separated list in another cell that the user can easily copy and paste into another program. It should be like this:-
1234,123461,123151,11321
What is the quickest way to do it ? Formulas ? I tried paste special transpose but cannot achieve it ? I can do it in macro but wondering if there are other simple ways to do it.
Any help?