Hi!
I have converted a dataset I have in Excel using the pivot_wider function.
The idea was to reduce file size, which I believe I somewhat achieved (from 305k rows x 14 columns to 27k rows and 109 columns).
The problem is when I try to export the data frame to excel.
When I take a look at the data frame in R the values appear as correct (see picture 1).
However, when I open the excel file created from the write_xlsx formula, all values are missing in the newly columns (picture 2).
I have also attached the script (picture 3).
Help are highly appreciated!