Transposing from Long to Wide and Aggregating Rows with Matching ID in R: A Comprehensive Guide