but then my CSV changes and spaces are removed automatically and all letters get capitialized.Vos Viewer take this csv and get me with a wrong outputs. Also two column merge in a single column.

library(readxl)
scopus_274 <- read_excel(“C:/Users/hp/Downloads/scopus_274.xlsx”)
View(scopus_274)
library(readxl)
wos_185 <- read_excel(“C:/Users/hp/Downloads/wos_185.xlsx”)
View(wos_185)
combined <- mergeDbSources(scopus_274, wos_185, remove.duplicates=”T”)
write.xlsx(combined, file = “final.xlsx”)

I want a clean and readable format data that matches my format. Then how do I merge both files?