The whole school information table is sheet2.

Name in column A information 1- information 5 in column B: F,? The following figure

The class information table is sheet 1.

Also, the name is in column A, and the information 1- information 5 is in column B: F.

Enter the formula of B2.

=VLOOKUP($A2，Sheet2！ $A:$F，COLUMN()，)

Pull right? Pull down again

The effect is as follows