Converting Matrix To Column In Access 2010

I'm trying to convert a matrix within a table (m x n) to a single column. So basically

1 2 3
4 5 6
7 8 9

to

1
2
3
4

5
6
7
8
9

I would do this in excel, but the problem is I have already over 1 million rows, and I'm converting 48 columns into one (too much for excel). Is there a way to do this via a macro or query?

The other catch is that I want to repeat Column A (which has the username) with each row of data, for example

Joe 1 2 3
Sam 4 5 6
Jeff 7 8 9

to

Joe 1
Joe 2
Joe 3
Sam 4
Sam 5
Sam 6
Jeff 7
Jeff 8
Jeff 9