Sorting Dilemma

[DoubleTap]

I have an Excel Sheet that has data I want to sort alphabetically in even
numbered rows and comments about the data in odd numbered rows. How can I
sort data in Row 2 for example and have Row 3 move with it?

Row 2 has lots of cells across with personal data relating to people and Row
3 is a single cell with text that goes completely across the legal page.

Row 1 is the header row with labels for the data. Also this sheet has about
400 excel lines down the page.

Thanks in advance if you can help me.....

 

[DoubleTap]

For some reason it did not work. I am using Excel 2003 and did not find a
"Paste Special" under the "Data" drop down. May be a new feature for 2007.
I appreciate the help and I see the route you are taking, some steps just
couldn't be completed.

 

[Sheeloo]

Sorry, it is under DATA

You can also right click and choose Paste Special

 

[DoubleTap]

Still not working. It is taking all of the comment lines and placing them
together and all of the names together.

Let me start over with more detail on the actual Excel cell, row, column, etc.

Row 1 is headers all the way across with titles naming the columns A to Q.
Row 2, Cell A, is a Non - Excel Line Number I entered for tracking the name. I do not want this number to move with the sort. This is like a line number on legal documents I added to help guide others down the page due to the amount of rows. (Over 400)
Row 2 Cell B, is a last name, first name of a person that I do want to move alphabetically with sort.
Row 2 Cell C through Cell Q is personal data that needs to move with Cell B.
Row 3 Cell A has Text in this cell only that continues across other cells through Cell Q. This cell is formatted to align left and contains comments relating to the name in Cell B2 that needs to move with the name above it when sorted.

My desire is for all EVEN Excel rows with the name and the ODD Excel row
below it to move together when sorted alphabetically. For Example, Row 2 and
3, 4 and 5, 6 and 7 etc always stay together regardless of last name.

I may be able to understand better if i know what the formula is doing then
I can work through any other issues I have with it.

Thank You again for the help and your patience.

 

[Sheeloo]

I don't why I wrote DATA instead of EDIT... two times :-(

All I am trying to do is to add the Last Name, First Name to both rows so
that they remain together...

First sort column must be the new column

 

[DoubleTap]

Now it is coming together for me. Right now, both last and first name are in
the same cell. I may make a change where the first cell on each row is
identical then add text comments in the next column.
If you think of something eaiser, let me know.

 

[gwen]

The problem seems to be that you want some of the data in column A sorted
(the comments) but not all (the Line Number) and I don't think you can do
that. What I would do is make another column for your Non-Excel Line Number
that you will not sort. Then make a helper column.
In Row 2 of this new column put: = B2
Row 3: =B2&1


Copy and paste this down, then sort on this new column, excluding the new
Line Number column from the sort

gwen