Hi al, Can anyone help me to get the Desired Output Format as attached in the workflow. * The Required input Data is provided * The Designation mapping Sheet is Given * The Required output Format is Provided only for the BU = AWM and Designation From Director to Manager Level. Similarly we need the output of the count for all BU and All Designation. in the same format. Also I am attaching which Fields are relevant to which months. From F4-F12 Data is for the Month of January -23 F14-F23 is for the Month of February-23 and So on Till Jun-23 Can someone help to achieve the desired Format Data Transformation.yxmd February Data.JPG January Data.JPG

Data Transformation to the Desired Format

Hi al,

Can anyone help me to get the Desired Output Format as attached in the workflow.

The Required input Data is provided
The Designation mapping Sheet is Given
The Required output Format is Provided only for the BU = AWM and Designation From Director to Manager Level. Similarly we need the output of the count for all BU and All Designation. in the same format.