Send mail

[Srini84 (Srinivas Kadamati)]

@fairymemay

Check below post

How to group rows that share similar information into one row

Hello everyone, I have a small sample excel data table that contains duplicated values that I need to combine into single row. Initial table: [image] The highlighted rows are the duplicated rows that I want to combine. (Here is my initial table Sample Data.xlsx (8.8 KB) ) So the above table should look like this: [image] Product No and Date Issued columns have unique value and i would like to retain the information when combining the rows. Is there any way to accomplish this with UIPat…

You can refer as example

Mark as solution if this helps

Thanks