Excel Concatenate of a Concatenate

Hi @ValeriaCedeno and welcome to the Knime Community.

This can easily be done with the Moving Aggregation node

And the aggregation to use would be Concatenate, and use the semi-colon (";") as delimiter.

This should do:

Here’s some sample that I tested with:
Input data:
image

Results:
image

You can then rename the column to “Concatenate”

5 Likes