GROUP_BY_CELL
Concatenate all non-empty cells in a range into a single string with a separator.
=GROUP_BY_CELL(range, [separator])Restituisce: string
Panoramica
GROUP_BY_CELL takes all non-empty values from a specified range and joins them into a single text string using a customizable separator. The default separator is ", " (comma followed by a space), but you can specify any character or string as the delimiter.
Parametri
| Parametro | Tipo | Obbligatorio | Descrizione |
|---|---|---|---|
range | Range | Sì | The range containing values to concatenate. |
separator | string | No (, ) | The separator to place between values. Defaults to ", ". |
Esempi
Create comma-separated tag list
Join tag names from column A into a single comma-separated string using the default separator.
=GROUP_BY_CELL(A1:A5)Input
| SEO |
| Marketing |
| Content |
| Analytics |
Output
SEO, Marketing, Content, AnalyticsPipe-separated export format
Join product codes with pipe separators for system import.
=GROUP_BY_CELL(B1:B4, "|")Input
| SKU-001 |
| SKU-042 |
| SKU-099 |
| SKU-150 |
Output
SKU-001|SKU-042|SKU-099|SKU-150Build attendee list with semicolons
Create a semicolon-separated attendee list for a meeting invitation.
=GROUP_BY_CELL(C1:C6, "; ")Input
| Alice |
| Bob |
| Carol |
| Dave |
Output
Alice; Bob; Carol; DaveCreate slash-separated breadcrumb path
Build a breadcrumb navigation path from individual page names.
=GROUP_BY_CELL(A1:A4, " / ")Input
| Home |
| Products |
| Electronics |
| Laptops |
Output
Home / Products / Electronics / LaptopsMulti-line cell from list
Join values with line breaks to create a multi-line cell (enable text wrapping to see all lines).
=GROUP_BY_CELL(A1:A3, CHAR(10))Input
| Line 1 |
| Line 2 |
| Line 3 |
Output
Line 1
Line 2
Line 3Casi d'Uso
Email merge fields
Concatenate product names a customer purchased into a single field for personalized email templates.
Tag string generation
Build comma-separated tag strings from individual tag columns for CMS import or meta tag generation.
Meeting notes summary
Combine action items from a checklist column into a single summary string for meeting minutes.
Patient symptom lists
Join multiple reported symptoms into a single comma-separated field for patient records.
Ingredient lists
Concatenate individual ingredient entries into formatted ingredient lists for product labels.
Skills summary for resumes
Combine individual skill entries into a single comma-separated string for resume or profile displays.
Suggerimenti Professionali
Use CHAR(10) as separator and enable text wrapping for multi-line output in a single cell.
Combine with SORT to get an alphabetically ordered concatenated string: =GROUP_BY_CELL(SORT(A1:A10)).
Use " & " as separator to create natural language lists like "Alice & Bob & Carol".
For the reverse operation (splitting a string into columns), use SPLIT_IN_COLUMNS.
This function is the text-joining counterpart to COMBINE_ALL. While COMBINE_ALL outputs values as a vertical column, GROUP_BY_CELL combines everything into one cell as a single string. This makes it perfect for creating comma-separated lists, building compound labels, generating tag strings, or preparing data for export to systems that expect delimited text.
The function automatically skips empty cells, so you never get awkward double separators or leading/trailing delimiters in your output. It works with any range shape and processes values left-to-right, top-to-bottom within the range.
Popular separator choices include commas for lists, pipes for data export, semicolons for CSV-adjacent formats, line breaks (CHAR(10)) for multi-line cells, and hyphens or slashes for building compound identifiers. The function is commonly used in reporting dashboards, email merge templates, data transformation workflows, and anywhere you need to condense a column of values into a single summary string.
Errori Comuni
All values appear on one line despite using CHAR(10)Causa: Text wrapping is not enabled on the output cell.
Soluzione: Select the output cell, go to Format > Text wrapping > Wrap. The line breaks are present in the text but need wrapping enabled to display.
Returns empty stringCausa: The range contains no non-empty values, or the range reference is incorrect.
Soluzione: Verify the range reference points to cells containing data. Check that the data is not just whitespace (spaces look empty but are not empty cells).
Separator not appearing between valuesCausa: The separator argument was passed as an empty string.
Soluzione: Omit the separator argument to use the default ", " or provide a non-empty separator string.
Domande Frequenti
The default separator is ", " (comma followed by a space). If you omit the second argument, this is what will be used between values.
Empty cells are automatically skipped. You will never see double separators or leading/trailing separators caused by blank cells in the range.
Yes, use CHAR(10) as the separator: =GROUP_BY_CELL(A1:A10, CHAR(10)). Make sure to enable text wrapping on the output cell to see each value on its own line.
Yes, values are joined in the order they appear in the range: left-to-right within each row, top-to-bottom across rows.
The output is limited by Google Sheets' cell character limit of 50,000 characters. For most use cases this is more than sufficient.
GROUP_BY_CELL is similar to TEXTJOIN with ignore_empty set to TRUE, but it works across 2D ranges more intuitively and does not require the ignore_empty parameter. It also handles edge cases like null and undefined values.
Yes, the separator can be any string, including multi-character sequences like " | ", " -> ", or " --- ".
Funzioni Correlate
Inizia a usare GROUP_BY_CELL oggi
Installa Unlimited Sheets per ottenere GROUP_BY_CELL e altre 41 potenti funzioni in Google Sheets.
