Overcoming the Limitations of Pivot_Wider: A Tidyverse Solution for Complex Data Transformations in R