Extracting Post Code data from a CSV download

To get a number of workers at a particular postcode (as indicated in the induction form follow the steps below:

1. Download site data for the period you are interested in under the 'settings' tab

2. Open the CSV in Excel or Google Sheets

3. Insert a new column AFTER column B and label it 'Full_Name'. 

Concatenate the 'First_Name' and 'Last_name' columns to give you one unique full_name.

3. Create a 'Pivot Table'

Select Rows ' post code' and values 

This will give you table of Post Codes with number of workers who have supplied that postcode in the induction form.