Grouping assoc group data w detail

I need to create a flat file for export - there are multiple samples w several data fields but the first sample contains data that needs to be associated w each of the samples ie

Sample #   test   site   result        address     "GH"
              
001          5     kit     3        59 oak rd   "Detail"
001          6     kit     17        59 oak rd
001          7     kit      4        59 oak rd
002          1     sink     23        59 oak rd
002          2     sink     33        59 oak rd
002          3     sink     12        59 oak rd
002          4     sink     11        59 oak rd
003          9     tub      15        59 oak rd
003          4     tub      10        59 oak rd

the address is only associated with sample 1,
                                                                                 So the address is blank for samples 002 and 003
                                                                                  How do I carry this data down for the remaining samples?

if this is for the entire report just use a max(field) value. IF this changes throughout the report is it based on groups? On sort Orders? Something else?

A Work Order has several samples and each sample 1 or more tests. There will be many Work Orders in the extract - each with a different address. The Group Header would be Work Order# and the detail section has the sample#, data and address fields.

so if you are grouping by WO then can you just do a MAXIMUM(table.address,table.wo) and place this in the detail section? This assumes there is only one address per WO.

Thank you DBlank Worked perfectly!