Convincing a college to wipe your old record?

To clarify, I mean they require organic chem to transfer into UMASS Lowell as one of the prereqs of the degree I want to transfer into. I’d take the math and science courses at community college instead of applying at a state school. So when I do transfer I can focus on just my degree instead. Plus because CC is less expensive. I already have 150 credits from my AA degree.

*I just read your update. Would you suggest I talk with UMASS Lowell or Community first?

Update: Also unfortunately my old community college is threatening to kick me out on academic warnings if I don’t get my GPA up, even though my GPA is being affected by grades from six years ago. Maybe I’m better off going to a third community college. Lol! Yes I definitely will be meeting with an advisor very soon. Right now I have a 1.2GPA which is pretty bad.