split column and append new rows

[duncansleigh]

Hi,

I am trying to process some data from an external application. My starting table looks like this…

Col0 - Col1
“first line text” - “111;222”
“second line text” - “111;333;444”

I would like to split the values in Col1 and append a new row for each value …
Col0 - Col1
“first line text” - “111”
“first line text” - “222”
“second line text” - “111”
“second line text” - “333”
“second line text” - “444”

Any suggestions? Thanks.

[Aswin]

Sounds like a task for the Cell Splitter to turn cells like “111;222” into collections like [“111”,“222”], and then Ungroup to expand the collections downwards.

[duncansleigh]

Thanks for the pointer. Cell splitter then unpivoting worked.