Student scores listed vertically in columns need to be transposed horizontally in rows

I have a long vertical list of alphabetized student names with corresponding scores in columns. Each student may not have the same number of scores. I need to arrange the names vertically in columns but the scores need to be listed horizontally (in rows) in different cells. I cannot use macros but only formulas. For example:

A B
1 Ana 3
2 Ana 1
3 Ana 2
4 Bert 5
5 Cathy 3
6 Cathy 8
7 Doug 6
8 Doug 7
9 Doug 3
10 Doug 4

I need to present the data like this:

C D E F G
1 Ana 3 1 2
2 Bert 5
3 Cathy 3 8
4 Doug 6 7 3 4

Any help, please? Remember, I can only use formulas. Thanks.

Thanks for the quick reply AZ-XL. I am very pleased. I recognize that it is an array formula you used. Could you please tell me if each cell starting from I2 needs the Ctrl+Shift+Enter simultaneous keystrokes individually? Or do I highlight all the cells that have the similar formulas and do the CSE keystrokes at once? Thanks.

Thanks again AZ-XL. I now realize why the formula was not working when I copied it and expanded the range, even when I pressed Ctrl+Shift+Enter. It was because the cursor was not on the formula bar but on the cell itself. The cursor needs to be on the formula bar for this to work. Thanks again...I believe I am all set!

Yup, I just finished a report that would have taken me days to individually transpose. Thanks a lot. I clicked the star already and it's not letting me click some more...Last question: How do I mark this question "solved"? Thank you.