Fetch the row value of One column of Excel A Sheet with Sheet Excel B who has same column

Book2.xlsx (10.3 KB)
I have Excel Sheet with Sheet 1, 2, 3
Sheet 1: Name, Student, Class.
Sheet2: Name, English, Social, Maths…(Marks in Subject)
Sheet 3: Name, English, Maths.

How can go each row of name in Sheet1 and pass that to Sheet2 and get english and maths marks and paste it to Sheet 3 ?
Please help

Hi @Sudhir_P ,

The first 2 sheets can be read using read range and then using join datatable the 2 datatable can be merged with the condition of name = name . The output to be written in sheet3.
JoinDatatable.xaml (8.0 KB)

1 Like

thank you priyanka

1 Like

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