Horizontal numeric order

C

Catana

I am trying to arrange zip codes in horizontal numeric order so I can read
them like reading a paragraph in a book. How to do this please?

Thanks.
 
R

RagDyer

Do you just wish to sort horizontally?

Don't forget, except for XL07, you only have 256 columns!
OR
Do you want to go out a certain number of columns, and then drop down to the
next row, and continue in that fashion?

If so, how many columns do you wish to use?
 
M

Max

Catana said:
I am trying to arrange zip codes in horizontal numeric order so I can read
them like reading a paragraph in a book. How to do this please?
Click to expand...

One thought. Assume data in A2:A10. Copy the range, then right-click on say,
B1 > Paste special > Check "Transpose" > OK. This will paste it horizontally
into B1:J1.
 
F

Fred Smith

Why not just sort them? Just tell Excel you are storing left to right, not
top to bottom. If you need more help, let us know which version of Excel you
are using.

Regards,
Fred.
 
C

Catana

I am using Excel 2003. 11 rows and 8 columns. I have tried selecting all
cells and sorting horizontally but it does not work. Needs to read like a
paragraph.

90740 92602 92612 92614 92620 92626 92627 92646
92604 90742 92603 92618 92630 92663 92706 92709
90743 92701 92782 92660 92657 92648 92617 92625
92647 92683 92655 92843 90670 90638 90639 92835
92649 92653 92637 92662 92661 92651 92656 90720
92703 90705 92780 92707 92710 92606 92804 90620
92704 90630 90680 92841 92683 82845 92844 92802
92708 92840 92805 92806 92868 92867 92866 92861
92821 92823 92887 90621 90620 92804 92801 92833
92832 92831 92870 92807 92865 92886 92808 90703
92869 90623 90630
 
C

Catana

I tried that first suggestion to copy paste and transpose and I think it will
work.
Thanks to all of you for your help.
 
Top