Hi,
I have a table of data with some KPIs for each month of the year for each customer ID. All customers are supposed to have Jan to Dec (12 rows) with months with no data recorded as ‘zeros’. But some customers have fewer number of rows.
I am trying to find the customers with missing months and insert the corresponding number of rows(months) with null values for KPIs.
Please help.