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.....

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....

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" wrote:

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....

Sorry, it is under DATA

You can also right click and choose Paste Special
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....

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" wrote:

Sorry, it is under DATA

You can also right click and choose Paste Special
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....

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
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Sorry, it is under DATA

You can also right click and choose Paste Special
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....

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.

"Sheeloo" wrote:

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
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Sorry, it is under DATA

You can also right click and choose Paste Special
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....

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

"DoubleTap" wrote:

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.

"Sheeloo" wrote:

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
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Sorry, it is under DATA

You can also right click and choose Paste Special
--
Pl click the YES button
(if you see it - don''''''''t worry if you don''t),
if this answer was helpful.



"DoubleTap" wrote:

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" wrote:

Assuming that the value in A1,A3,A5,... uniquely identify the row...
Enter this in the first blank column (assuming Col Z) in Row 1
=A1
and this in the second row in that column
=Z1

Now select Z1 and Z2 and drag them down so that formulas are copied...
You will get =A2 in Z3, =Z3 in Z4, =A3 in Z5, =Z4 in Z5 and so on

Now copy Col Z and choose Data | Paste Special and choose Values...

Now Choose Col Z as your sort column...

Do test on a copy first...

--
Pl click the ''''Yes'''' button
(if you see it - don''''t worry if you don''''t),
if this answer was helpful.



"DoubleTap" wrote:

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.....