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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    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
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      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