seperating and sorting groups of data

[Jeff King]

I have a spreadsheet where I track employees by job number. The
spreadsheet is set up where Column A is the driver name.... and the
remaining columns are job data. Job data can take several rows. ie.
several jobs, separated by number on separate rows. I don't want to
clutter my spreadsheet with employee names on each row as I am not the
one who wants the spreadsheet formatted this way.

Is there a way to sort all the data in the spreadsheet by employee
name... and have the data in the rows "associated" with that employee
remain "attached" to them.

I realize that MS Access would be much better for this data than
Excel. But i don't have it. I am using Excel 97.

Thanks.

P.S. I know I should upgrade to 2003 Professional Edition, but this
decision is out of my hands. Please help.

 

[Gord Dibben]

Jeff

Duplicate the names in column A where you hace to then select all but the
first of the duplicates and Format>Cells>Font>Color>White.

Select column A and F5>Special>Blanks>OK

Enter an = sign in active cell then click on cell above and hit CRTL + ENTER
to duplicate the names.

With cells still selected Format>Cells>Font>White.

Also with cells still selected Copy>Paste Special>Values in place.

Gord Dibben XL2002

 

[Debra Dalgleish]

Or, use conditional formatting to hide the duplicates. There are
instructions here:

http://www.contextures.com/xlCondFormat03.html#Duplicate

There are instructions here for filling the blank cells from the cell
above. They're the same as Gord's instructions, but you'll have to
select a contiguous range of cells before you can copy and paste as values.

http://www.contextures.com/xlDataEntry02.html