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.

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