DSO Dates

I have a DSO which contains some master data which as the following fields:

Main_id u2013 Key field

Type u2013 Key field

No of units

I want to build a DSO which will be using this DSO as source and introduce a date field as follows:

Main_id u2013 Key field

Type u2013 Key field

Date u2013 Key field

No of units

If I have 100 records in the first DSO for 1 type, I want for example 36,500 records in the second DSO (1 years data). The No of units will remain the same for all records. Is this possible to write via transformation logic? Thanks