Wait, it hasn’t been a waste of time.
Forget the lecture that no education is ever a waste… I’m guessing you’re probably not in the mood to hear it, right?
But if you’re ready to transfer from a CC, that means you have-- or soon will have-- an Associate’s Degree,And that’s HUGE. A college degree of a any sort puts your job application in a different pile than those without a degree. It will help you, and statistics say you’re liable to earn significantly more over your lifetime than someone without that Associate’s Degree.
OK, a question for you: What do you want to do down the road? Where do you see yourself after you get that degree?
How about a college with Open Enrollment? That means they’ll accept anyone who wants to attend. Here’s one in in CA: https://www.nu.edu/admissions/undergraduate/transferinformation/ I’m sure there are others.
If you want this badly enough, go for it. But choose a major in which you’re likely to find success.