How can I merge cells in excel using UIPath

Help Studio
, ,
1

Hello…
I have an Excel sheet with two columns… “Bill No” and “Items” as shown below.

Bill No. Items
123 Air Conditioner
Mobile
456 Washing Machine
Hair Dryer
Kids Toy
Battery
789 IPhone

Here…
I want to merge “Air Conditioner and Mobile” in one row, “washing Machine, Hair Dryer, Kids Toy and Battery” in one row. How can I do that…?
Please help me…

Thank you in advance…

1 Like
2

Hey @Praw1n

You can build logic using two things,

  1. Excel VBA & invoke in UiPath

  2. Microsoft Interop library to manipulate Excel cells (Will recommend this)

Hope that helps.

Thanks
#nK

1 Like
3

Try this workflow,
groupby concat.xaml (13.3 KB)
I have used groupby (Bill No) concat items,
Now since some Bill no rows are empty , I am filling them up with the previous one until a new one is seen
Hope it helps,
Let me know if you have any doubts

1 Like