View Single Post
  #4   Report Post  
Jay
 
Posts: n/a
Default

i need to keep three rows together while i sort by column. so it will
be groups of three.

i thought to copy the name down three times, but is there a way i can
automate this? this is a sheet that gets updated everyday.


One way is to use a helper column.

I'm supposing that column A has the field to be sorted, and you want to
sort by the first of the three values.

In the helper column, put this in row 1:
=A1
Put the identical formula in rows 2 and 3.

Select the three cells and extend down for the length of the list.

Then select the whole table and sort by the helper column.