Moving multiple rows into one row

Another way: The whole table in one go:

Formula:

=LET(t,SteveStudentRoutingReport202307!A2:I999,n,TAKE(t,,1),u,UNIQUE(n),v,FILTER(u,u),r,HSTACK(v,DROP(IFNA(REDUCE("",v,LAMBDA(i,x,VSTACK(i,TOROW(FILTER(DROP(t,,1),n=x))))),""),1)),r)

In this formula it is not necessary to adjust the references when there are more or less students and or data.