groupByCell

Overview

Group a number of cells in only one

Video Example

Arguments

  • cells: List of cells that will be grouped

Expected Output

  • String: All the values separated by a comma

Text example

groupByCell(C5:F5) 
// Cell values: apple, banana, JohnMu, Cheese
// Returns apple, banana, JohnMu, Cheese in the same cell

Use cases

  • Group data scattered in several cells into just one

PreviousexistsInColumnNextmyReplace

Last updated