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.

Does anyone know if this can be done? How?