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 -->
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 -->