Here is my problem. I have lots of data in multiple columns that needs
matched up. here is an example.

col 1 col2 col3 col4 col5 col6 col7
anderson 23 33 43 brook 44 55
brook 34 55 4 zane 44 44
kissell 55 44 4 kissell 55 65

There are actually about 6 columns with names in them with with
corresponding data in the next two columns. I need to search and match the
names and put them in the same row. there will be some names in column 1
that are not in column 5 and vice versa. Basically I want to sort the data
so column 1 and 6 and all other columns with names and put them on the same
row so I can compare the data in the columns that go with the names across
the board. Hope I explained this correctly.
Thanks in advance