Merge Data Tables Horizontally

[Yoichi]

Hi,

Another solution is to use string manipulation as the following.

result = String.Join(vbcrlf,text1.Split(vbcrlf.tochararray,StringSplitOptions.RemoveEmptyEntries).Zip(text2.Split(vbcrlf.tochararray,StringSplitOptions.RemoveEmptyEntries), function(x,y) x+","+y))

Note : dt1.Rows.Count must be same as dt2.Rows.Count

Regards,