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
Question
Compress multi row records into one line in excel
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+46- Influencer
You can use an aggregator - aggregate on b-side designation and merge attributes
Thanks egomm, it works.