Hi @wu cong? , thank you for reaching out.
After applying merge on all the columns, you can replace ';;' with a single ';'Another method is Unpivot the table to set column names as rows.
delete the missing values
Pivot the table back to its original form. Please note you need row number/source row number / unique primary key to bring all the values in the same order.
Use the Merge transform to concatenate the row values with ;
I hope this helps. Please let us know if you have any additional issues.
Best,
Apeksha Prasad