Could you elaborate a little bit on your question? It is not clear what your desired output would be, also, there are some problems with your first dataframe, the column names have being read as a row.
Ideally, could you turn this into a minimalREPRoducible EXample (reprex)? A reprex makes it much easier for others to understand your issue and figure out how to help.
If you've never heard of a reprex before, you might want to start by reading this FAQ: