My excel sheet has three columns and tracks fluid level in a pipe:
A. Location
B. Date
C. Fluid Level

I am building an excel sheet to export the above data into a different database. I have two problems:

1. The data will be entered as it is collected at different locations on different dates but needs to be sorted by location. I think I could use a sort function to do this.
2. 2.The second problem I have is that I need data for every day but the data entry for a given location doesn't occur daily. The data does however, remain constant between dates. I want to duplicate the data between entries so that there is data for each date.

The sheet looks like this

Location | Date | Fluid Level
A | 09/01/2011 | 85
C | 09/04/2011 | 78
D | 09/05/2011 | 40
A | 09/10/2011 | 50

I would like it to look like
Location | Date | Fluid Level
A | 09/01/2011 | 85
A | 09/2/2011 | 85
.. | .. | ..
.. | .. | ..
A | 09/09/2011 | 85
A | 09/10/2011 | 50
C | 09/04/2011 | 78
D | 09/05/2011 | 40

Thanks