Login / Sign up
Table editor

How to Split a List in One Cell into Separate Rows

2026-06-20
Task

One table cell contains several values separated by comma or semicolon, and the result needs a separate row for each value.

Short answer

Open the list column, enable Change row structure in Additional settings, and choose Split values into new rows.

How to Do It in Eofferix

  1. Open the settings of the tags column.
    Opening the tags column settings in the Eofferix table editor
    The animation shows the settings icon under the tags column.
  2. In Additional settings, enable Change row structure and choose Split values into new rows.
    Split values into new rows setting
    The mode creates a separate result row for each value from the cell.
  3. Enter the separator, for example ;, and save the settings.

What matters for the result

  • The delimiter must match the real file: ;, , and line breaks are configured differently.
  • Trim spaces around values before splitting, otherwise red and red may become different values.
  • Check that SKU or product ID is copied to every generated row.

Before / After

Before

source data
skutags
SKU-100new;sale

After

result
skutags
SKU-100new
SKU-100sale

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up