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


--
jzc10
------------------------------------------------------------------------
jzc10's Profile: http://www.excelforum.com/member.php...o&userid=34205
View this thread: http://www.excelforum.com/showthread...hreadid=539676