Spilt cell into row

[SylviaK]

Hi 

I am trying to get from the below table to the output table given just below. I have tried the Text to column function using \n  as the delimiter to have each line in a separate row but that didn't work to start with. Any ideas? Many thanks in advance

Name	Category
Name 1	• X-555555 - sdfsdfsdfssdf sdfsdfsdf sdfsdfsd - sdfsdf&sdfsdf • X-444444 - sdf sdfsdf -sdfsdf-ewrwer • X-333333 - sdfsd sdfsdf8sdfsf sdfsdfs -sdf • X-111222 - sdfsdfsdf sdfs • 12345 - sdfsd sdfsdf bb rr - dsdf
Name 2	• 567890 - stthj khj 78 ztu -llf
Name 3	X-223366 - sdfsfsdf sdfsf sdfsdf
Name 4	• 33001 -sdsdf sdfsdf fff • 33662 - sdfsdf • B-668877 - sdfsdfsdfbsfsdf -sdfs
Name	New Column
Name 1	X-555555
Name 1	X-444444
Name 1	X-333333
Name 1	X-111222
Name 1	62266
Name 2	567890
Name 3	X-223366
Name 4	33001
Name 4	33662
Name 4	B-668877

[JosephSerpis · Accepted solution]

Hi @SylviaK I amended the workflow let me know what you think?

[SylviaK]

beautiful. it works. many thanks