Pivoting Help

Isaiah02

I am having trouble using the pivot function. Attached is a Screenshot of how I am trying to arrange my data.

in the above example I am trying to take the columns AAA, BBB, and CCC and place them under a column named measure. As well as create a Compliance column to hold whether or not the measure was open or closed as well as removing the Null values.

Any help is appreciated. Thanks!

MarkSnodgrass

You would use the Unpivot Tile and configure it like this:

MarkSnodgrass

You would use the Unpivot Tile and configure it like this:

MarkSnodgrass

This video walkthrough may be helpful for you as well.

https://youtu.be/2CgiDd0DsPc

Isaiah02

Thanks Mark!