How to merge rows in excel based on condition using Uipath

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

But the “Name” is same it is repeating again

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

I would appreciate if anyone helps me out


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.

Rachel Gomez