How to combine several records into one

[baroha0b]

I would like to combine values from multiple records, from one work sheet, into a single record ; example courses taken:

badeg # name date course-name
1234 xyz 1/01/2009 Math
1234 xyz 6/30/2009 Chem
1234 xyz 1/12/2010 Phys
1234 xyz 6/07/2010 Engl


New sheet should look like:

1234 xyz 1/01/2009 Math 6/30/2009 Chem 1/1/2010 Phys

Appreciate your help

Regards
<!-- / message -->

 

[gecs]

On a second thought, the formulas in I2 and I3, should be better if written like:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	badge #	name	date	course-name	*	badge #	name	*	1	2	3	4	5	6
2	1234	xyz	1/1/2009	Math	*	1234	xyz	date	1/1/2009	6/30/2009	1/12/2010	6/7/2010	*	*
3	1235	abc	3/1/2009	Chem	*	*	*	course-name	Math	Chem	Phys	Engl	*	*
4	1235	abc	6/15/2009	Phys	*	*	*	*	*	*	*	*	*	*
5	1234	xyz	6/30/2009	Chem	*	*	*	*	*	*	*	*	*	*
6	1235	abc	1/1/2010	Math	*	*	*	*	*	*	*	*	*	*
7	1234	xyz	1/12/2010	Phys	*	*	*	*	*	*	*	*	*	*
8	1234	xyz	6/7/2010	Engl	*	*	*	*	*	*	*	*	*	*
Sheet1

Now the range F1:N3 can be moved anywhere in the worksheet and the lookup based formulas are more explicit.