Hi,
I have an excel with Date column (with missing date) and value column. I have to fill the missing dates in the Date column with zero. Also, if same date in repeated with more than once, it should be consolidate with one date instance and the relevant values should be summed up with single value. And the series to be continued till the end of the month.
Attached the excel with Date column and Value column.
I have an excel with Date column (with missing date) and value column. I have to fill the missing dates in the Date column with zero. Also, if same date in repeated with more than once, it should be consolidate with one date instance and the relevant values should be summed up with single value. And the series to be continued till the end of the month.
Attached the excel with Date column and Value column.