Heyy ,


Column A
Water
salt

I want to take Column A from sheet 1 and create the following in another sheet. Row by row. Column A is going to have hundreds of entry and I would need to automate this process
cat/images/[column A]/type/an_[ column A]_color.jpg
cat/images/[column A]/type/an_[ column A]_color2x.jpg
cat/images/[column A]/black/an_[ column A]_black.jpg
cat/images/[column A]/black/an_[ column A]_black2x.jpg

e.g.
cat/images/water/type/an_water_color.jpg
cat/images/water/type/an_water_color2x.jpg

cat/images/water/black/an_water_black.jpg
cat/images/water/black/an_water_black2x.jpg

Thanks so much in advance