Performing Group-By Operations on Another Column in R Using Dplyr Package

Using Arrays for Conditional Aggregation in BigQuery: A Pivot Table Solution

Transforming Data from Long Format to Wide Format Using dcast() in data.table