Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the overall size of a spreadsheet? | Excel Worksheet Functions | |||
How can I change an Excel spreadsheet that has UPPER case to PRO. | Excel Worksheet Functions | |||
how do i change a spreadsheet into labels? | Excel Worksheet Functions | |||
Use DocProps in a change declaration | Excel Worksheet Functions | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |