how to offset a column with an empty field

Hello, i have a data set with somme empty field like this

I would like to shift just the data (all the columns) on the right so that it is identical to the previous one.

I suggest you split the table first using a Row Splitter so that the rows with empty cells in the column are in one table and the rest in the other. Then you can use the Column Filter to remove the column and the Column Rename node to fix the names of the columns that come after it. In the end you can use Concatenate to put the two tables together again.
Kind regards

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