Merge similar cells in a table

Merge similar cells means grouping repeated table rows by a stable key and joining the values from one column into a single result cell.

This is useful for tags, image links, properties, or category labels when a supplier sends one product across several rows.

Where to find it

1. Open the table snapshot.
2. Open the settings for the column whose values you want to join. For tags, open the tag column.
3. Open Additional settings and enable Change row structure.

How to set it up

1. In How to change, choose Merge similar rows.
2. In Cell to merge by, choose the key that identifies one product or record. In most tables this is sku, id, or another product code.
3. Leave Value / substring empty if every repeated key should be merged. Fill it only when the merge should apply to a specific value or a text fragment.
4. Keep How to match as Exact match when the previous filter is not needed or when you need to merge only specific rows. Use substring matching only for a text-fragment filter.
5. In Merge separator, enter a visible text separator between joined values, for example ; or any other separator already used in the source file.

What the fields mean

Example

The source table has two rows for the same SKU because the product has two tags. After merging, there is one row for that SKU and the tags are joined in one cell.