how to group a row so i can organise data by diff fields
 

I want to group data in rows so i can pick a column and reorder the whole
spreadsheet by rearranging the order of that column.

Maybe you selected your range, then Data|Sort

And then gave it the column(s) to use as the sort key(s).

im sure i used to be able to do wrote:

I want to group data in rows so i can pick a column and reorder the whole
spreadsheet by rearranging the order of that column.

--

Dave Peterson