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
Moahmed Tarmom commented
Can’t wait to see that achievement
Taqi Patrick commented
I agree with Wyn and Oz.
Oz du Soleil commented
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.