copying cell entries a set number of times into cells below



I would like to copy cell entries and paste them into empty cells a set number of times.

Here is an example:

I want to fill 2 cells (indicated by the 'number' column) with "Hello" from the 'text' column and 4 cells with the text "Bye" into the cells beneath.

RowID number text
1 2 Hello
5 4 Bye

That's what it's supposed to look like:

RowID number text
1 2 Hello
2   Hello
3   Hello
5 4 Bye
6   Bye
7   Bye
8   Bye
9   Bye


I have absolutely no clue how to do this. Maybe someone knows a node or a combination of nodes that'll do it?

Help is much appreciated!


1 Like

Hi Michael,

you can only fully achieve this with a Java Snippet or with a loop maybe.


Is there a reason Row Nr. 4 does not need the Hello Text?

We would e.g. have the Missing Value node, it has an option Last. And with this you can replace a missing value in a column with the last value in this column.

Best, Iris 

Hi Iris,

yes the cell in row 4 is supposed to stay empty.
But I believe the Missing Value Node could already help me a lot nonetheless. I’ll try to work around this somehow.

Thank you very much!