I have an excel file in which building projects are described (e.g. project (18XX007, 18XX011 etc), each project then has a different architect, engineer and contractor (but not all has everyone on them).
I then need three separate columns (one for architect, one for engineer and one for the contractor) in which the name of that category is written down for each project.
Solved by M. H. in 24 mins