Shell interview question

Create a pivot table in Excel using the included information.