I want to make a nice summary table of of all variables in my dataset
I used summary(df) and stored the result as an object,
next I used write.xlsx(object), the issue is that it writes it to an excel file with the names and the value combined in each cell so the excel file looks like
Variable Variable Mean: 1 mean: 3 sd: 2 sd: 4 NAs: 0 NAs: 5
instead of looking like
Variable Variable Mean 1 3 sd 2 4 NAs 0 5
Any suggestions? I am open to changing the way I create the excel or creating an html file, whatever will look nice that I will be able to upload to shared folders etc
Thanks so much!