First, it is “I don’t want to…” not “I can’t”.
Second, if you applied to your “dream” school and were rejected then you have shot your shot. The answer was no. Time to move on. Same as there is no ONE magic person for you there is no ONE magic school for you.
Third, I agree with all the other posters who pointed out how very different the schools you say you want are. If this was more than a fixation on a handful of famous names you would be talking about schools that are more similar to Columbia.
Finally, unless you are determined not to like it, you may be pleasantly surprised by how much you like the college you are about to attend. Every spring and fall we see posts from students who were determined to transfer, applied & were successful and then had regrets. What is important to you right now (as somebody still in thrall to a HS mindset) may well shift a lot when you get into a college reality.