Google Sheets Tips

Google Sheets Tips

To sort a row of columns:
Define the following formula on a blank row:
=transpose(sort(transpose(C3:H4)))
Then just copy the sorted row and copy...special..values only
Delete all but the copied row

Leave a Reply