I recently posted a quesition on merging cells but it I didn’t got any solution.
I modified the excel such that cells above have Time in/ Weight in and cells below() have time out/ weight out of SAME ID.
I need to concatanate the cells in another sheet as shown below:
I tried a WRITE RANGE of the excel and used a FOR EACH ROW IN DATATABLE. But how do I have the check for similar ID in order to concatanate the rows?
Can anyone help please?
UIPath_Excel_Scratch.xlsx (118.6 KB)