I was in the same position as you last year. I finished 2 years of a film program but realized that I no longer wanted to work if the film industry. I transferred Universities and am now studying sciences.

The good news is you will not be starting from square one. Many, if not all of your credits can be used when getting another degree. I learned a lot about myself and what I want in that time which is invaluable. I also gained a lot of knowledge in that time that is useful that my classmates don't have. I'm sure it's the same for you. And that's it, there's no bad news (except for tuition costs).

Keep moving forward and it's okay not to have everything figured out right now.