FG

Convert a column into a comma separated list

Fresh3 days ago
Mar 15, 20261181843 views
Confidence Score1%
1%

Problem

I have the task of creating a simple Excel sheet that takes an unspecified number of rows in Column A like this: 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?

Error Output

1234
123461
123151
11321

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Convert a column into a comma separated list

Low Risk

Assuming your data starts in A1 I would put the following in column B: B1: B2: 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.

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment