Convert excel column to comma separated list

Question

In Excel, I have a column which has 50 rows. Now I want to convert these 50 rows into a single cell with comma separated values. Is there a way to do it?

Answer 1

The CONCATENATE function in Excel can transform a column list into a list separated by commas in a cell. Please follow these instructions:

1. Type the formula =CONCATENATE(TRANSPOSE(A1:A7)&",") in a blank cell adjacent to the list's initial data, for example, cell C1. (The column A1:A7 will be converted to a comma-serrated list, and the separator "," will be used to separate the list.) Take a look at the images below:

2. Press the F9 key to highlight the TRANSPOSE(A1:A7)&"," in the formula.

3. Remove the curly brackets and press the Enter key from the formula.