The Andromeda Galaxy and the Rise of Modern Astronomy