Combine different row data for certain column and delete the row

[SH_94]

Dear community, 

May i know how can i use the alteryx to combine the data below dynamically and delete the row relevant.

I have also attached excel file for your reference.

Thank you.

[kathleenmonks]

Hi @SH_94 See the attached workflow to answer your question. 

[Luke_C]

Hi @SH_94 

Here's how:

1. Assign a group/ID to the records. I did this based on column A being not null.
2. Concatenate data, for ABCEF I did not use any separator. For D I used a comma based on your example

[PhilipMannering]

Maybe this will work,