Change layout of spreadsheet
 

Highlight your data, Copy, go to new spreadsheet, Edit, Paste Special,
Transpose

That should do it!

Carole O
"Glenda" wrote:

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!