Move head rows to a column

Hi everybody.

I’ve uploaded a csv that uses head rows, identified with specific value, to separate groups of row.

I need to move the data from the head row to a new column, updating the value when a new group starts.

Usually, with excel, I use a If instructions:

  • if head row → take value from specific column

  • if not head row → copy the value from this column, previous row

Is it possible to obtain the same result in Knime?

Thanks.