Appending data from excel to another excel with the same header

Help
1

Hi Everyone,

I would like to ask if there’s a way in getting data from one excel and paste it into another excel with the same student ID?

For example, the professor wants to upload the grades of his/her students to the master list excel. The unique header is StudentID.

Any help will be much appreciated. Thank you! :slight_smile:

2

Hi @pasimon ,

Here you go,I just pasted the values in sheet2 instead you can change the path in append range activity and try it ,it will copy the data in new excel.Student Info.xlsx (8.7 KB) CopyTheRowsDataPateinAnotherExcel.xaml (7.5 KB)

3

Hi RajeshT,

Thank you for your response. I tried you work and it’s working fine. But what I want to know is connecting 2 excel files and getting the data (grades) from excel2 by the use of Student ID, and paste it to excel1 to it’s respective StudentID.

Excel1
image

Excel2
image

4

Hi @Pasimon,

Just a question,do you want to merge the column(Student Id) from Excel 1 and Column(Grade) from excel 2 ?

5

ComparingTwoExcels_StudentID.xaml (20.1 KB)
Try with this,hope this is your expected.Student Info.xlsx (8.1 KB) New.xlsx (8.0 KB) New1.xlsx (7.9 KB)