Hi,
I want to sort the following (dots are to keep text in place to simulate columns):
B........item1
....................stuff i write about item 1
..............................more stuff
A........item2
I want to sort by the first column, and i would like all the "stuff" in other rows and columns below item1 to move with item1. the sorted sheet should look like:
A........item2
B........item1
....................stuff i write about item 1
..............................more stuff
I tried "group"ing the cells containing B and item1 and its stuff cells, but it didn't help. Any help? See attached sheet if this isn't clear.
thanks so much, I've spent hours on this little thing by now!
Cosmo
Bookmarks