如何将此列转换为行格式？

I can use Pivot but my table here has only 2 columns so I don't know how to go about with it. A class has maximum of 5 UserIDs so I want to have a ClassID and associated 5 user names. I can use Pivot but my table here has only 2 co