How to ‘Pivot Wider’ when you have only character values

Reshaping your data by pivoting from long to wide, or wide to long is used frequently when wrangling your data. The pivot_longer() and pivot_wider() function from the tidyr package does this job excellent in most cases. I have however had some issues when reshaping data containing only characters. This is my solution to this issue.