Ok, this is a bit of an odd request and will likely take a bit of brainstorming to figure out (if it's even possible that is).
Basically, what I have is a HUGE list of images that are being tagged automatically by a Photoshop script that writes the image name and tag to a .csv file. Since many of the images fall under multiple tag categories; I need a way to quickly merge the different .csv files (each .csv has only 1 tag in the second column) while preventing the image from showing up on multiple rows, instead appending any additional tags to another column on a single row for said image. Anyway, I've attached a workbook with an example of what the .CSVs look like and what I want the finished example to look like, as well as what I would get using a manual merge of the .CSVs into a single spreadsheet.
I'm assuming this will need to be done using a macro-enabled workbook if it's even possible. Anyway, thanks for any help with this!
exampleMerge.xlsx
Bookmarks