Skip to main content
Question

Compress multi row records into one line in excel


tannyngtf
Forum|alt.badge.img

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

ebygomm
Influencer
Forum|alt.badge.img+33
  • Influencer
  • July 9, 2019

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


tannyngtf
Forum|alt.badge.img
  • Author
  • July 9, 2019

Thanks egomm, it works.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings