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

How to Use a Loop in the IN Clause of the SQL Pivot Statement for Custom Data Rotation