pivot_wider code snippets in r

use pivot_wider to change two columns with values to wide format and keep others in long format in r in r

use pivot_wider to convert dataset to wide, and sort date columns from left to right in r