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

[TABLE="width: 919"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]Column B[/TD]
[TD]Column C[/TD]
[TD]Column D[/TD]
[TD]Column E[/TD]
[/TR]
[TR]
[TD]animal/images/dog/type1/an_dog_color.png[/TD]
[TD]animal/images/dog/type1/an_dog_color2x.png
[/TD]
[TD]animal/images/dog/black/an_dog_black.png[/TD]
[TD]animal/images/dog/black/an_dog_black2x.png [/TD]
[TD]1234567789[/TD]
[/TR]
[TR]
[TD]animal/images/cat/type1/an_cat_color.png[/TD]
[TD]animal/images/cat/type1/an_cat_color2x.png
[/TD]
[TD]animal/images/dog/black/an_dog_black.png[/TD]
[TD]animal/images/dog/black/an_dog_black2x.png [/TD]
[TD]1233434334[/TD]
[/TR]
[TR]
[TD]animal/images/ horse /type1/an_ horse_color.png[/TD]
[TD]animal/images/ horse /type1/an_ horse_color2x.png[/TD]
[TD]animal/images/horse/black/an_horse_black.png[/TD]
[TD]animal/images/horse/black/an_horse_black2x.png[/TD]
[TD]1223232322[/TD]
[/TR]
</tbody>[/TABLE]


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