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!
>