can i link 3 rows together and sort them as one unit?
 

I have a heritage spreadsheet that was set up with each entry using 3 rows. I
want to sort them together, so that all 3 rows for each record get sorted as
one. I can't figure out how to do this and the sheet is too large to change
the formatting now. I have been cutting and pasting to sort which is a little
ridiculous. Thanks!

can i link 3 rows together and sort them as one unit?
 

You can select the data columns you want to keep together
Choose Data | Sort
and specify the columns you want to sort on... You can specify first column
then second column and then the third columns

See http://www.contextures.com/xlSort01.html for details...

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"KirbyGene" wrote:

I have a heritage spreadsheet that was set up with each entry using 3 rows. I
want to sort them together, so that all 3 rows for each record get sorted as
one. I can't figure out how to do this and the sheet is too large to change
the formatting now. I have been cutting and pasting to sort which is a little
ridiculous. Thanks!

can i link 3 rows together and sort them as one unit?
 

You can string all the values together and sort on that. Let's say your
values are in A1, B1 and C1. In cell D1 enter =A1&B1&C1

If that doesn't work post back with sample data and the result you would like.

If it does work post back so we know!
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"KirbyGene" wrote:

I have a heritage spreadsheet that was set up with each entry using 3 rows. I
want to sort them together, so that all 3 rows for each record get sorted as
one. I can't figure out how to do this and the sheet is too large to change
the formatting now. I have been cutting and pasting to sort which is a little
ridiculous. Thanks!

can i link 3 rows together and sort them as one unit?
 

I would make a helper column. Put the following formulas into the first four
rows of the new column, copy down and then sort on that Column.

Row 1: =a1
Row 2: =a1&" "&a2
Row 3: =a1&" "&a3
Row 4: =a1&" "&a4

(assuming your data starts at a1)

Gwen

"PJFry" wrote:

You can string all the values together and sort on that. Let's say your
values are in A1, B1 and C1. In cell D1 enter =A1&B1&C1

If that doesn't work post back with sample data and the result you would like.

If it does work post back so we know!
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"KirbyGene" wrote:

I have a heritage spreadsheet that was set up with each entry using 3 rows. I
want to sort them together, so that all 3 rows for each record get sorted as
one. I can't figure out how to do this and the sheet is too large to change
the formatting now. I have been cutting and pasting to sort which is a little
ridiculous. Thanks!

can i link 3 rows together and sort them as one unit?
 

I'm sorry, that would be for four rows. For 3 rows:

Row 1: = a1
Row2: = a1&2
Row3: = a1&3
Copy down, sort on new column

Gwen

"gwen" wrote:

I would make a helper column. Put the following formulas into the first four
rows of the new column, copy down and then sort on that Column.

Row 1: =a1
Row 2: =a1&" "&a2
Row 3: =a1&" "&a3
Row 4: =a1&" "&a4

(assuming your data starts at a1)

Gwen

"PJFry" wrote:

You can string all the values together and sort on that. Let's say your
values are in A1, B1 and C1. In cell D1 enter =A1&B1&C1

If that doesn't work post back with sample data and the result you would like.

If it does work post back so we know!
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"KirbyGene" wrote:

I have a heritage spreadsheet that was set up with each entry using 3 rows. I
want to sort them together, so that all 3 rows for each record get sorted as
one. I can't figure out how to do this and the sheet is too large to change
the formatting now. I have been cutting and pasting to sort which is a little
ridiculous. Thanks!