Spreadsheet: 134245d1325128440-help-turning-two-columns-of-data-into-a-table-countifs-solution
Sheet: PivotSolution

Count of Values | Values
Category | For applicant | For authority | Partially upheld | Grand Total
Aberdeen City Council | 8 | 8 | 5 | 21
Aberdeenshire Council | 5 | 10 | 9 | 24
Accountant in Bankruptcy |  | 1 |  | 1
Angus Council |  | 4 | 2 | 6
Argyll and Bute Council | 3 | 1 | 5 | 9
Assessor of Ayrshire Valuation Joint Board | 1 |  |  | 1
Assessor of Lanarkshire Valuation Joint Board |  |  | 1 | 1
Assessor Tayside Valuation Joint Board |  | 1 |  | 1
Audit Scotland |  | 2 | 3 | 5
Board of Management of Carnegie College |  | 1 |  | 1
Board of Management of James Watt College |  |  | 1 | 1
Board of Management of Stevenson College Edinburgh |  |  | 1 | 1
Board of Trustees for the National Galleries of Scotland | 1 |  |  | 1
Caledonian MacBrayne Limited | 1 | 3 | 6 | 10
Care Commission |  | 3 |  | 3
Carnegie College |  | 1 |  | 1
Central Scotland Fire Board |  | 1 |  | 1
Central Scotland Police |  | 13 | 3 | 16
Chief Constable of Central Scotland Police and others |  | 1 |  | 1
Chief Constable of Dumfries and Galloway Constabulary | 3 | 2 | 1 | 6
Chief Constable of Fife Constabulary |  |  | 4 | 4
Chief Constable of Grampian Police | 1 | 9 | 6 | 16
Chief Constable of Lothian and Borders Police | 1 | 1 | 1 | 3
Chief Constable of Northern Constabulary | 2 | 7 | 2 | 11
Chief Constables of Central, Grampian, Lothian and Borders, [NAME] and Tayside Police |  |  | 1 | 1
City Building (Glasgow) LLP | 2 | 1 | 7 | 10
City Parking (Glasgow) LLP |  | 1 |  | 1
Clackmannanshire Council | 2 |  | 2 | 4
Coatbridge College | 1 |  |  | 1
Common Services Agency for the Scottish Health Service | 3 | 1 | 4 | 8
Communities Scotland |  | 2 | 2 | 4
Crown Office and Procurator Fiscal Service |  |  | 1 | 1
Culture and Sport Glasgow | 1 |  | 2 | 3
Dumfries and Galloway Council | 6 | 6 | 6 | 18
Dumfries and Galloway NHS Board | 1 |  |  | 1
Dundee City Council | 11 | 10 | 7 | 28
East Ayrshire Council |  | 6 | 1 | 7
East Dunbartonshire Council | 10 | 7 | 3 | 20
East Lothian Council | 6 | 2 | 8 | 16
East Renfrewshire Council | 2 | 6 | 3 | 11
East Renfrewshire Licensing Board | 1 |  |  | 1
Edinburgh City Council | 22 | 16 | 18 | 56
Edinburgh Napier University | 1 |  |  | 1
Falkirk Council | 3 | 7 | 8 | 18
Fife Council | 14 | 15 | 10 | 39
Fisheries Research Service | 1 | 1 |  | 2
General Teaching Council for Scotland |  |  | 1 | 1
Glasgow Caledonian University | 2 | 1 |  | 3
Glasgow City Council | 17 | 27 | 20 | 64
Glasgow Cultural Enterprises |  | 1 |  | 1
Glenfield Medical Practice | 1 |  |  | 1
Grampian Joint Police Board | 1 |  | 1 | 2
Her Majesty's Chief Inspector of Fire and Rescue Authorities |  | 1 |  | 1
Her Majesty's Inspectorate of Constabulary |  | 1 |  | 1
Her Majesty's Inspectorate of Education |  |  | 1 | 1
Highland and Islands Fire Board |  | 1 |  | 1
Highland Council | 4 | 9 | 5 | 18
Highlands and Islands Enterprise |  | 1 |  | 1
[NAME] | 3 | 2 |  | 5
Inverclyde Council | 1 | 5 |  | 6
Investors in People Scotland |  | 1 | 1 | 2
[NAME] of Further & Higher Education |  |  | 1 | 1
Keeper of the Records of Scotland | 1 |  |  | 1
Keeper of the Registers of Scotland |  | 4 |  | 4
Kenilworth Medical Centre |  | 1 |  | 1
Lanarkshire Valuation Joint Board |  | 1 |  | 1
Learning & Teaching Scotland |  |  | 1 | 1
[NAME] and the Trossachs National Park Authority |  | 1 | 3 | 4
Lothian & Borders Safety Camera Partnership | 1 |  |  | 1
Lothian and Borders Fire Board |  | 1 |  | 1
Lothian Buses Plc | 2 |  |  | 2
Midlothian Council | 1 | 3 | 1 | 5
Moray Council |  | 5 | 1 | 6
Motherwell College | 1 | 1 |  | 2
NHS 24 |  | 1 |  | 1
NHS Ayrshire and Arran | 2 | 1 |  | 3
NHS Borders |  |  | 1 | 1
NHS Education for Scotland |  | 1 |  | 1
NHS Fife | 2 | 2 | 3 | 7
NHS Grampian |  | 2 | 3 | 5
NHS Greater Glasgow and Clyde | 1 | 7 | 2 | 10
NHS Highland | 1 |  | 1 | 2
NHS Lanarkshire |  | 1 | 1 | 2
NHS Lothian | 2 | 3 | 2 | 7
NHS Orkney |  | 1 |  | 1
NHS Shetland |  | 1 | 1 | 2
NHS Tayside | 2 |  | 1 | 3
NHS Western Isles | 1 |  |  | 1
North Ayrshire Council | 1 | 5 | 4 | 10
North Lanarkshire Council | 9 | 13 | 6 | 28
North Lanarkshire Leisure Ltd | 1 |  |  | 1
Northern Constabulary |  | 1 |  | 1
Northern Joint Police Board |  | 1 | 1 | 2
Office of the Scottish Charity Regulator |  | 2 |  | 2
Orkney Islands Council | 2 | 1 | 2 | 5
Parole Board for Scotland |  | 1 | 1 | 2
Perth and Kinross Council | 3 | 4 | 9 | 16
Police Complaints Commissioner for Scotland | 1 | 4 |  | 5
Queen Margaret University |  | 1 | 1 | 2
Renfrewshire Council | 2 | 6 | 1 | 9
Scottish Agricultural College |  |  | 1 | 1
Scottish Ambulance Service Board | 2 | 1 | 2 | 5
Scottish Borders Council | 8 | 10 | 5 | 23
Scottish Children's Reporter Administration |  |  | 1 | 1
Scottish Court Service | 3 | 5 | 6 | 14
Scottish Criminal Cases Review Commission |  | 4 |  | 4
Scottish Drug Enforcement Agency |  | 2 |  | 2
Scottish Enterprise | 2 | 2 | 1 | 5
Scottish Enterprise Grampian |  |  | 1 | 1
Scottish Environment Protection Agency |  | 2 | 5 | 7
Scottish Executive and Her Majesty's Inspectorate of Education |  | 1 |  | 1
Scottish Further and Higher Education Funding Council |  |  | 2 | 2
Scottish Further Education Unit | 1 |  |  | 1
Scottish Futures Trust |  | 1 | 1 | 2
Scottish Government | 78 | 71 | 87 | 236
Scottish Housing Regulator |  | 1 |  | 1
Scottish Legal Aid Board | 1 | 8 |  | 9
Scottish Legal Complaints Commission | 8 | 4 | 8 | 20
Scottish Natural Heritage |  |  | 2 | 2
Scottish Parliament |  | 1 | 1 | 2
Scottish Parliamentary Corporate Body | 2 | 6 | 8 | 16
Scottish Police Services Authority |  | 1 |  | 1
Scottish Prison Complaints Commission |  |  | 2 | 2
Scottish Prison Service | 1 | 20 | 28 | 49
Scottish Public Pensions Agency |  | 1 | 1 | 2
Scottish Public Services Ombudsman | 3 | 9 | 5 | 17
Scottish Qualifications Authority |  | 1 | 1 | 2
Scottish Screen |  |  | 1 | 1
Scottish Social Services Council |  | 2 |  | 2
Scottish University for Industry | 1 |  |  | 1
Scottish Water | 15 | 2 | 5 | 22
Shetland Islands Council | 3 | 3 | 2 | 8
Social Care and Social Work Improvement Scotland | 1 |  |  | 1
Solway Shellfish Management Association | 2 |  |  | 2
South Ayrshire Council | 3 | 2 | 1 | 6
South Lanarkshire Council | 4 | 19 | 11 | 34
Stirling Council |  | 1 | 2 | 3
Strathclyde Fire Board |  | 1 | 1 | 2
Strathclyde Police | 4 | 29 | 12 | 45
Student Awards Agency for Scotland |  | 1 |  | 1
Tayside Police | 5 | 8 | 8 | 21
The Mental Welfare Commission for Scotland |  | 1 |  | 1
tie Ltd | 1 | 2 | 7 | 10
Transport Scotland | 3 | 6 | 4 | 13
University of Aberdeen | 1 |  |  | 1
University of Edinburgh | 2 | 3 | 2 | 7
University of Glasgow | 6 | 3 | 2 | 11
University of Paisley | 1 | 1 | 1 | 3
University of St Andrews |  | 2 |  | 2
University of Stirling | 2 | 1 |  | 3
University of Strathclyde |  | 1 |  | 1
University of the West of Scotland |  | 1 |  | 1
VisitScotland | 2 |  | 2 | 4
Water Industry Commission for Scotland |  |  | 3 | 3
Waterfront Edinburgh Limited | 1 |  |  | 1
West Dunbartonshire Council | 3 | 4 | 5 | 12
West Lothian Council | 9 | 5 | 3 | 17
Western Isles council | 3 | 2 | 1 | 6
Grand Total | 359 | 527 | 450 | 1336