I got 700 files that have many givens in their name, examples of how a name can be:
Number - Year - City - Kudak - Measurements - Mat - Name of tree
Number - Measurements - year - Kudak - City - Mat - Name of tree
The problem is that al the givens in the name are ordered in alphabetical order but they should all be in the following order:
Number – city – year – measurements – Kodak/Fuji – Mat/Glossy – Name of tree
There is a clear example in the attachments. The first 4 rows are how the names are when I copy them into excel, the second 4 rows are how I want them to be ordered.
It is difficult because some have for example Berlin in 'City' and others 'Amsterdam'. There are many variables.
I tried to give al givens that should be in the same column a certain color and then I tried to sort it by color but then it leaves out some rows.
Has anybody an idea of how I can order these givens without having to select them all one by one?
Bookmarks