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