How to add two common items in a same excel sheet

I have an excel sheet which contains some common items like (FAN IN MY SHEET ATTACHED HERE). I want to add the “PRICE”,“QUANTITY” of this common item (FAN) in the same sheet.That is I want a single row for each and every item.table3.xlsx (8.3 KB)
How can I do it??

Hi @arghade,
I think I already created this one.
I revised it and you may check this one: BlankProcess12.zip (143.6 KB)
Hope this helps :slight_smile:
Despi

Hi,
Use for loop, build data table and add data row activities.

Please refer the workflow for your reference.

Regards,
Pavan HTestFan.xaml (22.3 KB)

@Jan_Brian_Despi Thanks for your work brother. But my problem is slightly different. Here you have specified that FAN is the common item in this excel, but my problem is that I don’t know what item is common in the excel sheet. How to find the common item and then proceed further.

Hi @arghade,
Please see this file:
CommonItem.zip (143.6 KB)
If it is the solution to your need, please mark this as the solution.
Thanks and regards,
Despi