I hope to be helpful by linking you to this forum guide to asking questions.
I think a large part of what is holding back the effective communications, is a lack of example data,
which should help to make your comments on it more concrete.
FAQ: Tips for writing R-related questions - meta - RStudio Community
I will also link to r4ds which is a good way for anyone to learn R/tidyverse, and in particular data transformation https://r4ds.had.co.nz/