Pivot a Column of Values to a Comma-Separated List in Google Sheets

The TEXTJOIN function in Google Sheets can be used to merge multiple cell values into a single, comma-separated list, simplifying data management and analysis.

Suppose you have this data in a column in a Google or Excel spreadsheet:

And need the data formatted into a comma-separated list like this: SQL,PHP,HTML,CSS,C++,Java,Python

Image by Gerd Altmann from Pixabay

You can use the TEXTJOIN function in Google Sheets (and Excel) to create a comma-separated list of values from an entire column of rows.

For the example data above, I enter the formula using TEXTJOIN like this:

=TEXTJOIN(",",TRUE,A2:A8)

TEXTJOIN accepts 3 arguments or parameters:

1. The delimiter
2. TRUE or FALSE (to ignore empty values)
3. The text to join

Here is TEXTJOIN in action for this example:

Simple and easy!

More technical tips coming your way!

My day job has allowed me to learn many different technical skills in addition to PHP and SQL.

Pretty much daily, I use Python, Powershell, Google Sheets/Excel, MS Access, and AutoCAD Civil 3D.

I plan on sharing more small and digestible articles like this about tips and tricks I have picked up from such a diverse technical skill set.

So stay tuned!

Help me finish or make this article even better with your comments and feedback.

Thanks for reading!

Receive a free copy of my eBook, “10 MySQL Tips For Everyone”, when you subscribe to the weekly OpenLampTech newsletter.