Crosstab Style Datagrid for entry

[Kineticfaith]

I need to find a way to take a normalized table, and display it in a crosstab format for users to enter and edit data in a data grid. For Example:

Table Structure.
MONTH CLIENT AMOUNT PRICE
01/01/2007 FRANK 45 $25.00
02/01/2007 CARL 35 $30.00

I Need the data entry for this data to look like this in the datagrid.
| 01/01/2007 | 02/01/2007 |
|AMOUNT|COST | AMOUNT|COST |
FRANK 45 | $25.00
CARL 35 | $30.00|

I Hope that makes sense.

Unfortunately the data entry method is non-negotiable, you can probably guess this is currently being entered this way in excel, and the folks that pay the bill are not going to want to change the basic format for data entry.

I would appreciate any assistance or direction or simply a "It can't be done".

Thanks in advance.