Create separate files organized by a column value

[swilfong]

I have data in Excel. There are several thousand rows. One of the columns has a persons name. Each person has multiple rows of information.

I need to create either separate excel files for each person with their info or be able to merge it into a word document for them. There are a couple hundred people.

Can this be done? How?