Using Multiple Columns per Reference ID in SQL with Window Functions and Aggregation

Replicating Columns in Dataframe: Summing Up Values and Keeping Rows Unique with Base R, Dplyr/Tidyr, and Purrr