TaskPipes will be shutting down 30th November 2018. Please migrate any processes to an alternative solution before then.
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: