How do i get rid of the NAs to get the actual values

Can you confirm that you've watched the video @andresrcs posted above + and/or read the link he gave you in his first reply? I feel like you are trying to take a shortcut and missing the point of reprex and it makes it awkward for everyone involved.

In simple words - noone (except you) has access to the files on your computer. So if you want to someone else (not you) to help you, you'll need to find a way to put this data here. Take a look at, e.g., datapasta package. It should be helpful in this case. Also, take a look at couple of examples here of how people ask questions. Here is completely random example I quickly found - case_when() with heterogeneous date formats