How to merge rows in excel based on condition using Uipath

Help Studio
, ,
1

Hi All,

Please find the attached screenshot

Please check the “Name” Column and “Mon” “Mon OT” , “Tue” columns etc
the data was added in this format(Screenshot) In each column one value was filled rest all are zero

image
image1111×178 4.22 KB

But the “Name” is same it is repeating again

I am trying to remove this Repeating name make it into one like this

image
image1141×61 2.8 KB

I would appreciate if anyone helps me out

Thanks

2

Click the first cell and press Shift while you click the last cell in the range you want to merge. Important: Make sure only one of the cells in the range has data. Click Home > Merge & Center. If Merge & Center is dimmed, make sure you’re not editing a cell or the cells you want to merge aren’t inside a table.

Regards,
Rachel Gomez