Hiding rows & columns in Google Sheets declutters your spreadsheet for easier digestion. Hiding affects entire row or column move data to keep visible before hiding. Unhide rows & columns by ...

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

The larger a spreadsheet gets, the more likely you'll want to start hiding rows or columns or maybe you've been given a sheet that has hidden rows or columns.