TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.

How to split up data with multiple values in one cell

Sometimes you will find that there are multiple entries within a single cell.

A typical example is shown below:

What if we want each category on a new row?

TaskPipes has a built-in step called "Unpack Values in Cell", which allows us to select the "Category" column and define that we want to split every time there is a comma character.

We are left with the data as required: