[auxym]

I am not familiar with the R ecosystem, but have you tried PoweredQuery?

I had become my go-to for all sorts for all sorts of data munging in excel.