I am stumped on how to attempt this. I have read through some posts but here but I'm quite a novice at Excel so not sure what way to go.
I am trying to add metadata to sound effects files. They came with a PDF which I've converted in to an xlsx. Normally you get one line for each sound file and it's as easy as copying the description column and pasting it into the metadata writing program. Problem I have with this CD is that multiple sounds are recorded in one file, so the description is in multiple rows.
I need to combine all the descriptions for each file into one cell, then remove duplicate words, so I can then paste it into each single files description.
B column shows it's the same file by it's leading number.
File 1 = 1-1, 1-2
File 2 = 2-1, 2-2, 2-3, 2-4
File 3 = 3-1, 3-2, 3-3, 3-4, 3-5
and so on for 990 files
So for File 1 my output would be C2+D2+C3+D3 =
AIR, JET STRONG STREAM THROUGH ANIMAL, FOOTSTEP ANIMAL FOOTSTEPS IN DIRT: VARIOUS MOVEMENTS
Does this seem like it's doable? I tried banging my head on the wall but it didn't help ;)
Then columns don't show so well on this forum
CD #(A) Tr / In(B) Description1 (C) Description2 (D)
FS01 1-1 AIR, JET STRONG AIR STREAM THROUGH JET
FS01 1-2 ANIMAL, FOOTSTEP ANIMAL FOOTSTEPS IN DIRT: VARIOUS MOVEMENTS
FS01 2-1 APPLAUSE, CROWD SMALL INDOOR CROWD APPLAUSE WITH SLIGHT BUILD
FS01 2-2 APPLAUSE, CROWD SMALL INDOOR CROWD APPLAUSE
FS01 2-3 APPLAUSE, CROWD SMALL INDOOR CROWD APPLAUSE
FS01 2-4 APPLAUSE, CROWD SMALL OUTDOOR CROWD APPLAUSE WITH VOICES
FS01 3-1 APPLAUSE, CROWD SMALL CROWD APPLAUSE
FS01 3-2 APPLAUSE, CROWD SMALL CROWD APPLAUSE
FS01 3-3 APPLAUSE, CROWD SMALL CROWD APPLAUSE
FS01 3-4 APPLAUSE, CROWD SMALL CROWD APPLAUSE
FS01 3-5 APPLAUSE, CROWD SMALL CROWD APPLAUSE