Mail Merge using Excel 2010

[cmt1070]

HELP!!! I have an Excel 2010 spreadsheet with employee data across one row and below each employee row several rows of Issued Equipment and a column for Renewal. Each employee can have between 3-50 pieces of equipment (rows) and I don't want to manually add all of those columns to make it one record per row. Is there any way to loop through the rows using a mail merge or vbscript that will create one document for each employee with all of their equipment and renewal status listed?