Merge multiple rows into one or many

1

Hi everyone,
I want to show you a problem that I have never solved.
Imagine having multiple groups of rows in a dataset that need to be condensed into a single row per group.

This is the starting dataset:

immagine

This is the dataset I would like to obtain.

immagine

How do you think I can do it?

I am attaching the datasets for your convenience and added a Group column for better understanding of the problem.

Thanks!

start.dset (254 Bytes)
result.dset (242 Bytes)

2

Hi

Just use aggregate action with space as separator

Regards

merge rows.morph (3.7 KB)

1 Like
3

Oh perfect!
unfortunately I had never noticed before Concatenate option in Aggregate action :sweat_smile:

Very useful feature!!!

1 Like