Split a multirow string into different rows and columns

[gonhaddock]

Hello @DiegoCorreiaXTL
As a starting point, you may want to take a look into this topic:

Mulit-line string input into table

Hi @kienerj I’m not sure that I fully understood your your request. An example of input → aimed output would help… [image] Do you have a multi-line text in a cell like this one? [image] And you want to split it in rows. Or do you have a text split in rows? ‘Cell Splitter’ node delimiter == "\n" Then Unpivot [image] Then, do you want to merge it in a cell? ‘Pivoting’ ‘Column Aggregator’ node columns, wildcard == "*_Arr*" concatenate, delimiter == "\n" [image] BR

After breaking it into rows, you would probably need a cell splitter node, with space character as delimiter.

BR