how can I merge serval fields by some signal ,and skip the empty fields.

[WuCong]

such as Fields 1 -10.

when 2 is empty ,will only merge 1,3-10. 1;3;4;5;6;7;8;9;10

how can I get the result?

[APrasad_Tri]

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