Merge multiple rows into one or many

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)

Hi

Just use aggregate action with space as separator

Regards

merge rows.morph (3.7 KB)

1 Like

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

Very useful feature!!!

To learn more about EasyMorph visit easymorph.com.