Not sure if exactly what you are looking for, but here it goes:

SELECT row1 + row2 AS multirow FROM table GROUP BY multirow

>Dear all,
>
>What function I will create to make an sql and concatenate the result of multi-row into one row when i issue group by.
>
>Thanks in advance.
>Ed