I think this can be achived using a combination of the dplyr and tidyr packages but, we don't really have enough info to help you out. could you please turn this into a self-contained REPRoducible 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: