i am struggling to concatenate a column based on the grouping of another column.
I have column ID and column Partners. i need to make a concatenation (column Concat). For each ID i need to concatenate all its partners. If i have blanks i need to exclude it (ID=B).
Any suggestion would be great.
Thank you in advance