Function to sort/order horizontally?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ed - 06 Apr 2004 22:51 GMT

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

Reply to this Message

Frank Kabel - 06 Apr 2004 22:55 GMT

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

Signature

--
Regards
Frank Kabel
Frankfurt, Germany

> 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
[quoted text clipped - 4 lines]
>
> Ed

Reply to this Message

Ed - 06 Apr 2004 23:16 GMT

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

Ed

> Hi
> try the following
[quoted text clipped - 20 lines]
> >
> > Ed

Reply to this Message