Good morning,
I have photos that were exported with an excel file. The photos names are a Photo ID number which are also in a row that link up to a string of data within the excel file. I'm trying to get the renaming tool to find the match the photos name to the name within the excel sheet and CONCAT 2 rows of data to form a new name.
An example being file name 00e115ed-58d8-44cf-9ff4-1ed98b65350c.jpg, finding it within row DF of the excel file, and using the data within column S for a block name, and between column T to AZ for the row name (if blank then move on to next column until data is found for name), then CONCAT that into a new name being B4 R55. The data only has a number to the "B" and "R" will need to be added before the CONCAT data.
I hope that this explains what I'm after and I hope there is a way of doing this easily enough.
Thank you,
Dan