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?

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.

Thank you DBlank Worked perfectly!