This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Got a bit of a weird one for you - We have survey data completed where respondants can complete the survey in English or French. If they choose English, they answer questions 1-5 (each of which is an individual column). If they answer French, questions 1-5 remain NULL and they answer answers 6-10.
However, we are analysing the data in aggregate, regardless of language.
I am trying to do something like:
If respondant chose English, then columns 1-5 are the english answers
If respondant chose French, then columns 6-10 (containing the answers) are swapped with columns 1-30 (which are NULL).
The simplest example I can think of is to manually filter Language = "French". In that "true" path, remove 1-5 and rename 6-10 as 1-5 using a select tool. in the "false" path (english), deselect the fields 6-10 in a select tool and then union both together selecting "auto position by name".