Sorting columns
 

I have a worksheet where the first column is an index with customer number.
I the other columns, from B onwards, I have the item numbers each customer
has ordered.
I would like to sort the item numbers that is stored outside each customer
number, how can this be done?

one way;
Highlight the data range DataSortOptionsSort left to right
HTH

"Petterq" wrote:

I have a worksheet where the first column is an index with customer number.
I the other columns, from B onwards, I have the item numbers each customer
has ordered.
I would like to sort the item numbers that is stored outside each customer
number, how can this be done?

This was a step in the right direction, however as not all cells have a
value, the values in the first row will decide for the subsequent rows.

Example data:

7800,3,5,6,7
7801,3,6,8,9,10

The first value is the customer number, and the next ar different values in
the other columns. When sorting, the 3 and the 6 is placed above one another,
but there will be no value under 5 and 7. There are serveral blank celles in
between before sorting.

PetterQ

"Ray A" wrote:

one way;
Highlight the data range DataSortOptionsSort left to right
HTH

"Petterq" wrote:

I have a worksheet where the first column is an index with customer number.
I the other columns, from B onwards, I have the item numbers each customer
has ordered.
I would like to sort the item numbers that is stored outside each customer
number, how can this be done?