You may want to start by checking out this article on exporting your user list and putting it into Google Sheets so you can work with team members on account cleanup in real time.
You'll use a few basic functions to organize your data, so let's go over those:
1. To select the whole sheet for sorting, click the top left cell. The entire sheet will highlight, to indicate that you have selected the entire area.
2. Click Data, Sort Range to sort the entire data set.
3. Select how you want to sort:
Select "Data has header row" to omit the first line in your sort, and populate the column headings in your "Sort by" dropdown list.
Select the sort order using A-Z or Z-A.
Add another sort column, if you like.
Click the blue "Sort" button to reorganize.
Let's get started!
Make a "Notes" column by inserting a new Column A. This will come in handy when you need to leave notes or questions.
Sort for Admin, User Admin, Z-A.