Merging cells with the same ID

Wojciech Glowacki
Wojciech Glowacki Contributor
in General

Hi,

I'm looking for a solution for en example on the left side of the screenshot. I want to merge the values from Column 1 for the same ID (expected solution on the right). Would be very grateful for any suggestions :)

image.png

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Group by ID column then Aggregate Column1 Sorted group values (you can select if it should dedupe this comma separated list):

    image.png

Categories