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!