@Raja.G
Before applying the Pivot, try to filter the data table using the filter data table activity to remove the blanks.