microsoft excel – How to auto duplicate row of data(non-values) for data entry form to change one field?

For my data entry spreadsheet, I have multiple rows of data(address, DOB, identifier,name) for the same person with only one field that’s changing(delivery date). Since it is all in random locations(due to the disorganised way the hard copies were filled), how do I easily duplicate the row of data for the same person in a new row so that I only need to change only the delivery date?