Get the distinct 1st column by Concatenating the values of the 3rd column based on the unique values of 2nd column

Hi Folks,

Given Input -
image

Required Output -
image

I’m trying to use a foreach loop to achieve this. Please Let me know if you have any better solution.

Thanks in advance :slight_smile:

@Tanuja_Gopalasetti Check this workflow and test with the Original Data that you have.

GroupByAndSum.zip (1.9 KB)

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.