Function to sort/order horizontally?

  • Thread starter Thread starter Ed
  • Start date Start date
E

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
 
Hi
try the following
- select your range
- goto 'Data - Sort - Options'
- choose 'sort by columns'
 
Back
Top