How can i fill the empty fields using the data from another field ?

[#1]

Hey everyone i need a suggestions and i wanted to know that how can i fill the empty rows of table using a field(hours) in the same table.

Let's say i have a table containing columns(Story, Block, Time, 1-2, 2-3 ,3-4.....)

These 1-2 , 2-3 ... are the columns name which are showing the time slots and i want to fill these time slots using the "Time" filed on the basis of hours which i have extracted from Time field.

Kindly give your suggestion so i can make a report.

Attaching the desired report interface as well.

thanks in advance

[jonathandienst]

This might help:

How to populate a sparsely populated field