Google sheet synchronization trouble

Hello Dear community,

I would like to ask whether somebody encountered a similar problem… I am trying to analyse data synchronized from Kobo to google sheet. The problem is that at the beginning of the project, we slightly changed some questions, which creates a separate column in the spreadsheet, while it is still the same variable. I would need to copy-paste the values from one column to another, in order to be able to make my analysis. But this does not seem to be possible in the synchronized google datasheet.
Anyone would have any idea how to go around it?

Thank you very much


Welcome to the community, @run_one_health! Have you tried going through our support article that should solve your issue: