Merge two rows into a single row

Hi brdrok ,

After performing group by → accountkey with the operation set to all rows, you'll see a column displaying “table” for each row.
Don’t expand it using the arrows; instead, click the gear icon next to the grouped step in applied steps.
In the dialog, select only the investortotaling column and remove the others.
The grouped column will now become a list.
Right-click the investortotaling column header and choose extract value.
Pick your preferred delimiter (such as | or ,) to combine all investor codes into a single text string for each account key.

Thank you,
Tejaswi