Course completion

[regb]

I have a large spreadsheet with students down the rows in column A an
courses listed across the row 1. When a student completes a course
match the row and column and place a c in the cell, otherwise they othe
columns have a u.

I would like to select one student and have it list all the course
completed and then after all the courses uncompleted. I would like thi
information copied to worksheet 2.

Thank