Find and insert data from another sheet into the first

Hi friends!

could you help me, i faced such situation, i have a column in one sheet (may contain empty rows), according to this column i need to pull data from another sheet and insert this information in next to column in first sheet. For example, if the first column of the first sheet contains the word cat, then it will definitely be in the second sheet, but I need to pull out the data of the adjacent column in the second sheet and insert it into the first and yes, sorry for my English

Hi @asiljan.7muse join datatable activity and in condition gives column names (use inner join)

Hi @prasath_S I tried in your method, but it only connected the titles of both sheets to me
could you please share xaml

i have attached the excel file as an example
1.xlsx (9.3 KB)


The result sheet is something you are expecting or is it something you are getting now?

hi @Pravin_Patil1 the result i expect



i apologize for the late reply, thank you for your help, it works!

No Problem.

All the best and Happy Automation :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.