I would use a combination of Row_number() over(ID) and then pivot the data set on the Row_number and the users ID.

I hope this helps