New answers tagged

0

Interestingly enough, collapsing the rows first and then the columns will produce a different result Your question is best and easiest done via a script. The full code is here: The basic steps are: row collapse the grid, using: var r = row.filter((a) => { return a && a != ''}); column collapsing = transpose, row collapse it, and then ...


0

Have you considered creating a form instead of sharing a spreadsheet for data input? Form responses automatically appear in a separate tab in the spreadsheet in a row-oriented fashion and are thus easy to process with spreadsheet functions such as query() and filter(). If the users need access to the spreadsheet for some reason, you can just protect and hide ...


0

To display fractions in the dropdown, you need to convert the decimal/formatted value to a text value. For example: =text(A1:A5,"# ???/???") If the resulting dropdown value is to be used in a calculation, then you need to convert it back to a number. For example: =left(B10,search("/",B10)-1)/right(B10,len(B10)-search("/",B10)) ...


0

Google Sheet doesn't include a built-in feature to remove rows having "invalidad data", in Google Sheets the "data validation" is done by cell and this prevent to enter a invalid value or marks the cell with a red triangle in the top-right corner. Removing rows with "invalid data" might be done, manually or automatically by ...


Top 50 recent answers are included