Adding that the National Student Clearinghouse has all records of student enrollment at any college, which colleges (and grad schools/med schools) do verify. So you do need to submit all transcripts from all institutions that you have attended when you apply to college/transfer colleges and/or grad school.
Obviously you will have to take the course again. Before deciding where to take it, you should check how the college you took it at handles repeating a class…some transcripts would show both grades, some allow grade replacing.