Microsoft Access Move Multiple Rows In Table1 To A Single Row In Table2
With help from Jonathan Fite who pointed me in the correct direction.
Via SQL:
TRANSFORM FIRST(RESULTS)
SELECT RECORDNUM
FROM Table1
GROUP BY RECORDNUM
PIVOT TYPE

Via GUI choose Totals and Crosstab then: