Please how do i display a table like this
1 John, Smith
Using SQL in MS access
You can use filters or sort by order to group rows vertically as shown in this gif - http://i.imgur.com/rZWI5fA.gif
But I'm not sure if you can get all the users horizontally in the same row unless you write a custom script.