Trying to put data in a table that corresponds to a date

[superdaw]

Apologies if this is a really simple problem but I'm a bit new to excel.
I want two tables to be essentially a range of dates with data values set at specific dates.
So column A has dates, column B has data
Table A has only the dates for which a data point is recorded, i.e. 1/1/13 = x, 15/2/13 = y, 3/6/13 = z
But I want to get all data points into a table with all dates (1/1/13, 2/1/13, 3/1/13......) descending and data points next to their corresponding dates in the original table.
This will mean dates with no corresponding data points will leave a blank cell in the adjacent column.

There must be a simple way of making excel assign the data values to their corresponding dates in the blank table but I can't work it out!
Please help!

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.