Lack of awareness of the behavioural disorder has meant many people found it difficult to hold down jobs. But proper diagnosis and support are allowing more employees to make the most of their talents