Hi gurus
I have an online form that makes a spreadsheet in google sheets but as we all know excel rules, so i paste the data into an excel.
A recent problem (though i've made no changes on purpose) is that now when i paste, it ignores & skips out any blanks
Hence if i copy the answers to Questions 1 to 5, but only questions 1, 3 & 5 are answered, it just pastes the answers 1, 3 & 5 as if they are answers 1, 2 & 3, and as my excel has loads of formulae to interpret the answers, everything is a confused mess.
I should also note that as there is some transposing and workings within google sheet, I'm copying formulae results from google sheets, and it is excel is ignoring values of this type :
=if(1=0, "how odd!" , "")
but i've checked and pasting in excel behaves the same even if i'm copying values rather than formulas from google sheets...
Can anyone help? I'm hoping it's just a setting that needs changing?
Thanks in advance!
Bookmarks