I am working with an old document that was created to capture names during
several years. The worksheet is set up so that there are 2 columns (first and
last name) under each year, side by side. Vertically, the list is
alphabetical by last name.

For example if a person is listed for 5 consecutive years, their full name
is written out 5 names across the row. Or if a person is listed only for one
year, their name is written only once across the row.

I would like to move from all the years into one column. Is there a way to
do this other than manually cutting and pasting??


Thanks