How can I convert the Excel column to a separate list?
I am a data analyst and I am currently working on a data analysis project using Excel sheets. Currently I have an Excel spreadsheet that contains a column of data that represents the names of products. Explain to me how can I convert this particular column of product names into a single comma-separated list by using Excel functions or formulas.
In the context of database analysis Excel is among the most powerful tools. In your provided scenario you can convert excel column to comma-separated list by using the function of “TEXTJOIN”. This particular function is available in the recent versions of Excel.
Let’s consider a scenario where your product names are in column A ( from A1 to A10), then you can use the formula:-
= TEXTJOIN(“ , “, TRUE, A1:A10)
This above formula in Excel would concatenate the values in cells A1 to A10, separating them with a comma and even space. Moreover, an argument like “TRUE” ignores the empty cells in the range.
If you are using an older version of Excel then you can use the functions “&” and “IF” to convert the Excel column to comma comma-separated list.