Group and Transpose a Table

Hi Folks, I'm really keen to figure out an efficient way to solve the following data transformation challenge.   I have a monthly report which provides Employment Status (NEW or EW) for a list of ...