Concatanating Cells in Excel

Help Activities
, , , , , ,
1

Hi,

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.
image

I need to concatanate the cells in another sheet as shown below:
image

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?
Thanks!
UIPath_Excel_Scratch.xlsx (118.6 KB)

2

@Yudhisteer_Chintaram1

Check as below

image
image2338×1165 235 KB

Once you got the output, use for each row and check for the blanks and select the other with the value

Hope this may help you

Thanks

1 Like
4

Okay let me try.

5

Is it possible to use a For Loop and a write cell activity?
@Srini84

6

@Yudhisteer_Chintaram1

Instead of Write Cell activity you can use Assign activity

For reference check below

Hope this may help you

Thanks