If i have 2 columns (A & B). A contains a list of names and B a list of subjects. For each name in A there are multiple subjects in B.

What I want to do is create a sheet with 1 row for each name, with a column
containing each subject.

Any help apreciated