Format Column data to be Col and Row

I found a simliar code example

student 1 Eng A
student 1 Math B
Student 1 Hist B
Student 1 Geog C
Student 2 Eng D
Student 2 Math C
Student 2 chem D

convert it into the following format:

Eng Math Hist Geog Chem
student 1 A B B C
student 2 D C D

Please Login or Register  to view this content.

However, it just shows
STUDENT ENGL MATH HIST GEOG CHEM
in sheet 2.

How can it work without defining strings?

Just use the cell and range of worksheet.