Concatenate multiple column into one single column in excel sheet using specific character

Help Studio
1

Hello

I have concatenate multiple column into one single column in excel sheet using specific character(|).

eg.
Multiple column in excel sheet :
Num1 Num2 Num3 Num4
101 102 103 104
201 202 203 204

Output: One column

          Num1|Num2|Num3|Num4
          101|102|103|104
          201|202|203|204

which activity use to concatenate multiple column to single column in excel sheet.

Thanks & Regards
Minal Patil

2

dt.AsEnumerable().Where(function(x) x(“Column1”).ToString & x(“Column2”).ToString() = “Columnw3” ).Select(function(y) y).Count.ToString

3

Concatenate with specific symbol.

4

If columns are dynamically changes, so how can I concatenate columns. Because in my excel sheet columns are dynamically change.

5

Read the data…
for each loop
assign values
row1 = row(0).tostring
row2 = row(1).tostring

assign activity:
row3 = row+" specific character "+row2
write line
row3