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

[KirbyGene]

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!

 

[Sheeloo]

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

 

[PJFry]

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!

 

[gwen]

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

 

[gwen]

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