Understanding and Resolving the "Invalid Multibyte String 1" Error in R When Spreading Data

Understanding the Transitivity of pivot_longer() and pivot_wider() in R: A Solution Using rowid_to_column()

Maintaining Column Order in tidyr's spread() Function: A Comparative Analysis of Two Approaches