Merging multiple rows into 1 row?

HI @alvin.c.apostol26

How aboy this expression to sum ?

(From d in dtData.AsEnumerable Where Not (isNothing(d("Net Price")) OrElse String.IsNullorEmpty(d("Net Proces").toString.Trim)) Select v = CDbl(d("Net Price").toString.Trim)).Sum(Function (x) x)

Refer this docs to Merge a cell

Regards
Gokul

1 Like