I'm freaking out so bad

Last term I talked to my counsellor. She tells me I should take calc 3 over the summer. No big deal right? I book two classes online, both cancel due to low enrollment and no time to register for another. None of the colleges in my area teach it. Only college that teaches it is two hours away heavy traffic. Confirm through the university that it is acceptable to transfer. Each class is 3 hours, four days a week, for 8 weeks. I get there so exhausted and only get about 4 hours of sleep a night because of how little time I have. Don't love it but i need the class so I do it anyways. I'm absolutely miserable but I get it through it and pass.

I contact the registrar because they haven't transfered the credits and I need it for a specialty class I want to register for. After two weeks of back and forth where I have to bug them to respond they finally tell me I should have turned in a form three weeks before enrolling in the course. No one told me about this nor is it on the website. I can't even find the form.

By now the class I wanted to take is completely full, I have no idea what I'm going to do about my schedule, and most importantly I feel so bad for disappointing my counsellor and cant figure out how I'm going to tell her. How am I going to tell my parents or friends? Class literally starts monday and I've been crying so much I haven't been able to eat in two days. 

Literally don't know what I'm going to do and feel like i wasted everything