Numerous sets of Data and filtering the dates

[Sup3rHanz]

I'm trying to download individual countries 12 month historical data for bond prices. These prices along with each countries heading are then compiled into a single worksheet. The problem I have is for some countries the dates are different I.E some days will be missing, as the country chose not to report on that particular day or there was a time zone difference/national holiday etc. therefore when I try to compile each countries data into a single worksheet with a single set of dates (every day for a 12 month period) it doesn't compute properly when trying to make chart comparisons between countries. I need each countries data to specify #n/a if there is no entry for the date, so all the data finishes equally on the data timeline with no excessive 0's

Please help...

The data is downloaded for each individual country from investing.com

[AliGW]

Welcome to the forum.

If you are using PowerQuery to source the data, you should be able to merge your data with a table containing a full list of dates so that you have a cell (an empty one) for each day of the year

[Sup3rHanz]

Thanks for your reply, I'm not using power query, I am downloading and each set of data individually and then copying it across

[AliGW]

OK, well you might want to look at PQ, then. But the principle is the same - if you have a full list of dates and map your downloaded data to it, you can automatically create the missing 'entries'.