Forum Discussion
Unpivot other columns with null values
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.
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.
Hi,
I have a similar scenario. But I cant replace null with blank space because there are hundreds of columns and rows. Any other workaround?
Thank you!