Skip to main content
  • EN

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

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

Thanks egomm, it works.

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.