Solved Problem with Unpivot Data

[sameer79]

Hello All,
I am enclosing a sample file where I have two sheets: Schedule and Result

From Schedule Sheet I have created Result using Unpivot feature of Power Query but it is only showing the 'Parcels' Category
Other Categories are not coming on the Result Sheet.

What am I doing wrong?

TIA

 

[ricklinty]

When you do unpivot, all the status with null value will disappear
You can replace all the null value to -, then status with - value won't disappear
Add a replace step before unpivot step as below that replace null to -
= Table.ReplaceValue(#"Removed Columns",null,"-",Replacer.ReplaceValue,List.Skip(Table.ColumnNames(#"Removed Columns"),6))

The enhance file is attached as well

 

[sameer79]

Thanks Rick