Pivot a count

Pivot pet counts so each species becomes a column, per sex. Use "len" as the aggregate function to count rows.