I have daily data of several countries in excel file. But many data are missing at irregular intervals. For example, For Bangladesh, I have data from January 1 to February 22. But for india, I have data from January 10 to Feburary 22. But for Sri Lanka, I have data from jan 22 to feb 22. The end data is same but not the starting values. I want to have all the countries data in time series format( january 1 to Feburary 22) with no gaps.
NB: The observation for which data is missing, the date is also missing. For example, I dont have date for India from January 1- January 10, so i will have to create the dates along with observations( can be missing/zero) for those dates.
Any idea how to do that?