I have a spreadsheet laid out like a list with indented items. The first
7columns contain data pertaining to an individual, while the next 5 columns
contain data about events occuring to that individual. The problem is that
one individual may have several events, but the personal data is filled in
only once, for the first event; the first 7 columns are simply left blank for
subsequent events (these are all listed following each other).

there are several thousand events in this list. How can I copy the personal
data so that each row is complete, with all columns filled in?