Unpivot other columns with null values

[Dom87326]

Hello all, 

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!

[dhruvinushah · Accepted 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.

[anil600232]

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!