Merging multiple rows into 1 row?

Learning Initatives Automation Starter
1

Hi UiPath,

I need help with my situation.

Let say I have the data below:

image
image1903×581 60 KB

As you can see when I add 10.5 and 11 it’s equal to 21.5 with is the total.

By default Row 2 and 3 are separated. I just merge it and that’s my goal.

Hope someone can help me

Thanks!

2

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