I have a long list of husbands and wives where for example:
HUSBAND 1's last name is in cell H2
HUSBAND 1's first name is in cell I2
HUSBAND 1's age is in cell K2
On the next row is that husband's wife:
WIFE 1's last name is in cell H3
WIFE 1's first name is in cell I3
WIFE 1's age is in cell...