Group By?

I want to take the serial ID of several values in different rows in one table and insert them into a single row of another table.

 

Would the 'group by' command be the best way to do this?

 

Bob