put together the same values from multiple cells into one cell

Hello everyone :smiley:
My data so far looks like this:

And I need it to look like this:

image

Somebody knows how to put data like this together?

Thanks in advance,
Denis :smiley:

Hi @denajaha

Did you check already the Duplicat Row Filter node?
gr. Hans

5 Likes

It seems you want to get rid of the duplicate information.
The duplicate node filter node would help you to remove the duplicate information in that table.

2 Likes

Hi @denajaha,

If you want to keep unique values and also the “keywords” and “cost category” column only, you can do it by using the GroupBy node in a single step. (Add those 2 columns as grouping columns without any aggregation columns)

Or you can use the Duplicate Row Filter as @HansS has suggested and then use the Column Filter node to exclude unnecessary columns.

:blush:

4 Likes

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