I have the following table:
I'm trying to make it look like this, by unpivoting other columns except 'Respondent name' and 'Respondend unique ID'.
However I loose respondent 28230144 and city San Antonio. Is it possible to perform unpivot operation while keeping the null values?Thanks!
Go to Solution.
Try replacing the null value with a blank space in the four questions columns that you are unpivoting.
After you have done this, select the Respondent Name and Resp ID column and press the "Unpivot Other columns". This will work to give you the San Antonio result in your Unpivot.
Please give thumbs up and mark this as the solution. Thanks.
View solution in original post
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!