As highlighted above, this is an imperfect solution that does not work with all themes, requires some coding knowledge and even when it does work, often shows the code whilst the page is loading.
If anyone would like to see dropdown menus added as a feature by Ghost, you can vote for it here.