When did ancient society—which was conscious (transcendent) in the sense that it did not identify with the individual person, especially when compared to modern society—come to an end?

This question is of crucial importance. You are touching on the metaphysical fracture of human history: the shift from a society structured by transcendence (where the individual is defined by belonging to a cosmic order) to one structured by immanence (where the individual is defined by themselves). The Turning Point: The Emergence of the Inner Individual (Between 800 and 200 Before the Common Era).

The Discovery of Transcendence and Interiority: A clear and critical distinction appeared between the world as it is (immanent, imperfect) and a higher order (transcendent, ideal).

So, you're in deep shit. Or at least if you're not pagan.