Sorting columns with multiple rows

S

scain2004

I have a range consisting of three rows.
Basically a data group of one column with three rows.
The first row of the column is a date, the second a job type, the thir
a department.
Each column/row group corresponds with a job number at row 1, column
of the range

I would like to sort the range starting with column B according to th
date value.

Any suggestions as to how to do this (keeping the other two row
carried with)?

Any further explanation, I'll to do if needed.

Thanks.
 
B

Bob Kilmer

scain2004 > said:
I have a range consisting of three rows.
Basically a data group of one column with three rows.
The first row of the column is a date, the second a job type, the third
a department.
Each column/row group corresponds with a job number at row 1, column 1
of the range

I would like to sort the range starting with column B according to the
date value.

Any suggestions as to how to do this (keeping the other two rows
carried with)?

Any further explanation, I'll to do if needed.

Thanks.
Click to expand...

Insert two helper columns. Populate one with a repeating triplet of numbers
that gives a serial number to each member within each three row range
(1,2,3,1,2,3,1,2,3,etc.) . Populate the second column with the sort key so
that all members of the three row range have the same sort key. Sort the lot
with the key column as primary, and the serial column as secondary. Remove
the helper columns.
 
B

Bob Kilmer

Bob Kilmer said:
Insert two helper columns. Populate one with a repeating triplet of numbers
that gives a serial number to each member within each three row range
(1,2,3,1,2,3,1,2,3,etc.) . Populate the second column with the sort key so
that all members of the three row range have the same sort key. Sort the lot
with the key column as primary, and the serial column as secondary. Remove
the helper columns.
Click to expand...

Previous post assumes the sort keys are unique. If they are not, add a third
helper that gives that effect. Populate this column 111,222,333,444,etc.
Sort by key column, the 111 column, and the 123 column.
 
B

Bob Kilmer

Transpose the three rows into a single row. Sort on your key. Untranspose
the single row into three.
 
P

pwdiaz

It's not perfectly clear what you want to do but if you want to sor
from left to right (or visa versa) based on the date while keeping eac
column coherent then you can use the sort function on the data menu.

Data>sort>options>sort left to right>

select the row you want to sort then

press "okay
 
Top