Function to sort/order horizontally?

[Ed]

I know I can select data and sort and order it vertically by row data. But
can I select data and sort it into an order by columns? I have lines charts
based on data that was dumped in kind of haphazardly. The X-axis points are
set by the values in row 2 across each column - but they are out of order.
I can grab each one manually and move it, but it would be faster if there
was a simple function or menu command to do it. Any hope here?

Ed

 

[Frank Kabel]

Hi
try the following
- select your range
- goto 'Data - Sort - Options'
- choose 'sort by columns'

 

[Ed]

That simple! "Ask and ye shall receive" - thank you, Frank.

Ed