Filtering and sorting excel columns

Sorting and filtering to capture certain information is possible through creating the Master CSV Report. This can be generated by navigating to Profiles > Children > Top Right Export > Master CSV 

To sort and filter certain information please follow these steps: 


1. Click the number 1 in the top row in the Excel spreadsheet - This will highlight all categories. 



2. Click the Sort & Filter Icon > Click Filter - This will give all categories an arrow to sort 



3. Click the arrow which has the category you wish to sort and filter by ascending or descending.