Hi!
We have a spreadsheet which lists several names in cells in column G. We used "text to column" to break out the names into separate cells (now columns H - R), but the names are horizontal on the spreadsheet and we really need them to be vertical so we can sort them. Is there any way to do this?
Thank you for your help!
Spoor
impossible spreadsheet?
-
With out an example of to view I would suggest looking at transpose.
Copy
Paste special
Click transpose
Click OKI would strongly suggest you test o a copy of your work in the first instant, until you get this as you want
Hope this helps
Jack in the UK
-
OK
Post back on this feed if you need more help, please do not start a new feed, when you reply this post will bounce back to the top, no new feed required
Jack
-
-
Hi
YES
If I read this right you wish to not sort top to bottom but left to right, if so then try this I hoe you get as you wish
Save a copy of you work and rename to TEST so we can play and project your work, when you have it solved them of cause try on real work, just in case.
Select rows or columns to sort
Data
Sort
Options
Click left to right tick boxHave fun, good luck
Jack in the UK
-
I will try that!!!
Thank you very much!!! -
My pleasure
Jack in the UK
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!