Pivoting Help

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!