How to fill values in the template using find and replace

[ilovecoding]

Template format :

Lets assume below is my template. I have all the students details together but is there a way i can drop them all together and it will fill in the existing template? 

Template	Fees	Expense	Books	Uniform
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
1st input file
Student 1	100	15	35	45
2nd input file
Student 2	100	20	40	35
3rd input file
Student 6	100	25	30	50
Output:
	Fees	Expense	Books	Uniform
Student 1	100	15	35	45
Student 2	100	20	40	35
Student 3
Student 4
Student 5
Student 6	100	25	30	50
Student 7

[OTrieger]

@ilovecoding 

You can add RecordID at the after the template, join the data from the different, union the left side for those students that do not have data and then sort the data based on RecordID, add select tool and then remove the RecordID

[MelGibson]

Bring your blank template in - join them with the student field - union the join output and the template output then sort student field 

[ilovecoding]

What if there are 50 students? Can it be done without creating 50 input files at the initial stage?

[OTrieger]

@ilovecoding 

No you do not need 50 inputs. Just use RecordID it will solve the problem. 

[ilovecoding]

How can i do that? 

Please note that below is my original output. Example is only for 2 students however there are as many as 50 and format of the all 50 files are same. I have managed that put them in the row as below, however that is only for 1 student. How can i keep feeding in the student data and template kept on updating one after another like a loop?

Student A	Sem1	Sem2
History	25	33
Geography	30	29
English	32	36
Maths	41	38
Student B	Sem1	Sem2
History	25	33
Geography	30	29
English	32	36
Maths	41	38

	sem1 History	sem2 History	Sam1 Geo	Sam2 Geo	Sam1 English	Sam2 English	Sam1 Math	Sam2 Math
Student
Student A
Student B
Student C
Student D
Student E
Student F
Student G
Student H
Student I
Student J

[OTrieger]

@ilovecoding 
With a Batch Macro. Your control parament will be Student. Connect the control parameter tool to filter tool and then you loop your WF for each of the students. Add Macro Output tool and the result will be your full report with the data.

[ilovecoding]

Hi, can you help attaching the workflow as i never used this function before, simultaneously im exploring this option now