Google-sheets – How to retrieve unique rows by an index column in Google Spreadsheet

I have had a similar issue, with trying to sort a UNIQUE dataset.

the way i got around it was by creating another sheet and using the '=QUERY()' function to call the sheet with the UNIQUE list on it. This way you can add a ORDER BY statement to the query.

so in your example, Expenses has the source data, the summary table has the Summary data (with the UNIQUE function),

and then add a new sheet called "Summary Sorted" and then add the query function like this:

=query(Summary!A1:B4, "SELECT A,B ORDER BY B DESC")

Here is an example spreadsheet to demonstrate:

Yes, I currently do this for a form system once it receives all necessary approvals I move all of the form submission's values to a new sheet that only contains approved submissions.

The following code gets the values of the row you would like to move and copies it (maintaining the original row) to the destination sheet. Assume that the submissionrow variable is the index of the row you want to move and the sheet variable is the source sheet you are checking the values on.

var lastcol = sheet.getLastColumn();
var rowvalues = sheet.getRange(submissionrow,1,1,lastcol).getValues();
var destinationsheet = SpreadsheetApp.openById(spreadsheetId).getSheetByName(nameofthedestinationsheet);
var rownum = destinationsheet.getLastRow() + 1;
destinationsheet.getRange(rownum, 1,1,lastcol).setValues(rowvalues);