so I have a .csv files with sales leads info.


The database where I download this from provides husband and wife info.
Nice to have both spouses names but the database repeats the whole dataset.
Is there a way to take just one column (ie male's first name and merge it with the first name column of the females first name and just ignore the rest of that second dataset?)

EXAMPLE:

John Smith (555) 555-5555 1234 any street AnyCity, Georgia XXXXX-XXXX
Judy Smith (555) 555-5555 1234 any street AnyCity, Georgia XXXXX-XXXX

combined into

John Judy Smith (555) 555-5555 1234 any street AnyCity, Georgia XXXXX-XXXX


Any Help would be appreciated!
Thank you !