Need concatenate syntax to concat multiple columns with delimiter (,)

Hi All,

I need code in vba to concat multiple columns. My scenario is we have data in column A to G, where a1 to G1 are headers. Need to concat the columns like a2,b2,c2,d2,e2,f2,g2 till a50,b50,c50,d50,e50,f50,g50... (eg: '101', 'Arun','11001','12/25/1990','32-A, Sabarna Flats','Mumbai','50000').

Thanks in advance,

K@v!..