I have 5500 or so rows/lines of data with 5 columns. Column A is
program1's last names, B is program1's first names, C is just a visual
barrier between name sets, D is program2's last names, and finally E is
program2's first names.

The first thing I need to do is space out column D and E to correlate
with column A and B.

For example:

Code:
--------------------

A B C D E ...
1 prog1last prog1first prog2last prog2first
2 Adams Bill Adams Bill
3 Alberts Mary Alberts Mary
4 Bates Joe Becker Frank
5 Becker Frank Bodine Howard