Here is a custom Excel Macro function that will do it as well to merge multiple rows into one row, comma separated
Follow This Step :
- Alt + F11 to open the VB editor
- Paste the code below in the edit window
- Then put this formula in any cell
Here is The code :
Function CommaCon(rng As Range) As String
' CommaCon Function
Dim Temp As String
Temp = ""
For Each Cell In rng
Temp = Temp & Cell.Value & ", "
CommaCon = Mid(Temp, 1, Len(Temp) - 2)