Generate dynamic rolling 365 day Calendar with Names pulled from another table

Thanks, but this isn't what I need. The names are in a diffrent table. I need to take each name and attach the dates to them in a seperate table.   This shouldn't happen in the Names table.

Starting with:

Start    End

1/1/1  1/2/1

1/2/1  1/3/1

and ending with:

Start   end     Name

1/1/1  1/2/1   Bob

1/2/1  1/3/1   Bob

So:

In New Table "Filled"

(

     For each name in Table.Names

           (

                Generate 365 date span rows

           )

)

Output being rows of:

Start Date - End Date - Name

1 row per date span per unique name from the seperate names table.

If this was a normal program I'd store the names in an array and then iterate over the array to generate a new array with the dates and names.

Thanks