Question

Compress multi row records into one line in excel


Badge

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


2 replies

Badge +10

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

Badge

Thanks egomm, it works.

Reply