Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Power Query - Add option to retain all cells (nulls and errors) when using Unpivot Other Columns

Using Power Query to Unpivot other columns is an amazing feature but it automatically removes nulls and errors.

Add a drop down down (maybe an advanced option) to Unpivot Other to allow the keeping of all items

21 votes
Sign in
(thinking…)
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Wyn Hopkins shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Oz du Soleil commented  ·   ·  Flag as inappropriate

    I like this idea.
    It'd be easy to filter out nulls and errors if they aren't needed AFTER unipivoting. But when there are multiple columns and the nulls are needed, it's messy to replace all the nulls with 0 before unpivoting.

Feedback and Knowledge Base