trying to convert a matrix into a table

[roberttran]

I am trying to convert a matrix into a table either using excel or access.

Here is what I'm talking about:
In matrix form, the left column is a list of users and the top row across are menus. The matrix will have an X wherever the user had access to a specific menu.

Row #1: username, menu1, menu2, menu3, menu4
Row#2: user1, x,x,o,x
Row #3: user2, x,o,x,o

In table form, the top row will be the header row with the field names and I want a list of a user and menu. That means there may be more then one entry for a specific user if he/she has access to more then one menu.

Row #1: username, menu
Row#2: user1, menu1
Row#3: user1, menu2
Row#4: user1, menu4
Row#5: user2, menu1
Row#6: user2, menu3


any ideas?