Split cell contents into rows.

Hi,

I have unable to split the cell contents into rows. Data is in following format, a cell has this data. And I want to convert this cell data into 3 rows.

Data1
Data2
Data3

While viewing past posts, I have found following node, but I am not able to add it, may be it has been removed.

Hello nikola_tesla,

I couldn’t completely understand your requirement. But I think this can help you

Flow
image

Input Data
image

Output data
image

Column expression

replace(column("Notes"),"\n","," )

Cell Splitter Configuration
image

You can play around the settings as you require.

If this is not what you have required, can you update your question with sample input and output fields?

As for the node that you have referenced, I think it is of a different usecase

2 Likes

Thanks you, this is what I was look for. Again thanks for your help. :slight_smile:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.