Change layout of spreadsheet
 

I have a spreadsheet that I will need to import into Access that is in the
wrong layout.
My spreadsheet is laid out like this
UserID UserName Store1 Store2 Store3
Store4

I need the layout to list the stores vertically not horizontally. I've been
told that I will have to come up with a solution on my end.
Any ideas. Last time I used cut and paste. I've also tried deleting cells.
Please help!