Forum Discussion

schilders's avatar
schilders
Icon for Helper I rankHelper I
2 years ago

How to Pivot Columns and Use Static Column Headers?

I have a business object that attempts to pivot a dollar amount into one of serveral categories.  The applied step is as follows: Table.Pivot(#"Duplicated Column1", List.Distinct(#"Duplicated Colum...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Before the Unpivoting step, replace the null with blank.  If this does not help, then share some data to work with and show the expected result.  Share data in a format that can be pasted in an MS Excel file.