Creating custom path using excel cell values

[ChuckFin]

Extract the information from column A and Column B from one excel document and create another excel document and copy each row in the first 4 columns while placing the cell values from column A in the new document path structure.

Source: Document 1 Column A Column B dog

Column A	Column B
dog	1234567789
cat	1233434334
horse	1223232322

<tbody>
</tbody>

Goal: Document 2

Column A	Column B	Column C	Column D	Column E
animal/images/dog/type1/an_dog_color.png	animal/images/dog/type1/an_dog_color2x.png	animal/images/dog/black/an_dog_black.png	animal/images/dog/black/an_dog_black2x.png	1234567789
animal/images/cat/type1/an_cat_color.png	animal/images/cat/type1/an_cat_color2x.png	animal/images/dog/black/an_dog_black.png	animal/images/dog/black/an_dog_black2x.png	1233434334
animal/images/ horse /type1/an_ horse_color.png	animal/images/ horse /type1/an_ horse_color2x.png	animal/images/horse/black/an_horse_black.png	animal/images/horse/black/an_horse_black2x.png	1223232322

<tbody>
</tbody>

sample
Column A
dog
I want to take Column A from sheet 1 and create the following in the sheet
animal/images/[column A]/type/an_[ column A]_color.jpg
animal/images/[column A]/type/an_[ column A]_color2x.jpg
animal/images/[column A]/black/an_[ column A]_black.jpg
animal/images/[column A]/black/an_[ column A]_black2x.jpg

Please help?
Thanks