Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output should consist of four columns (Doctor, ...

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.

Essentially a pivot table lets you question the information you have, rather than having to work it all out yourself. Since the ability to quickly sift through figures is paramount for a journalist ...