Compress multi row records into one line in excel

Hi ALL

I have excel data as below

and I want to consolidate each designation's fibre records into one row like below:

Can anyone suggest how to do it?

Thanks a lot.

Input data

Page 1 / 1

You can use an aggregator - aggregate on b-side designation and merge attributes

Thanks egomm, it works.

Sign up