Finding Consensus in Two Out of Three Columns and Summarizing Them with R Code

Melting a Pandas DataFrame from Wide to Long Format Twice on the Same Column

Reshaping Wide Data to Long Format with Tidyverse's pivot_longer Function in R