Matching Values Across Columns for Row-by-Row Retrieval in R

Creating Cross-Tables with Filtered Observations in R using dplyr and Base R

Calculating Aggregate Mean in R using dplyr Package: A Tutorial

Using data.table and dplyr for efficient R Data Frame Matching

Reshaping Pandas DataFrames from Long to Wide Format with Multiple Status Columns

Handling Duplicate Groups in DataFrames: A Comprehensive Guide to Identifying and Removing Duplicates

Converting Long Data Frames to Longer Data Frames with Running Indicators in R

Modify Variable in Data Frame for Specific Factor Levels Using Base R, dplyr, and data.table

Here is a rewritten version of your response:

Reshaping Data from Wide to Long Format while Collapsing Variable Values for Same IDs in R