There are a number of questions and answers about summarising multiple variables by one or more groups (e.g., Means multiple columns by multiple groups). I don't think this is a duplicate.
Here's what I'm trying to do: I want to calculate the mean for 4 variables by
Displacement, then calculate the mean for those same three by
Horsepower, and so on. I don't want to group by
carb simultaneously (i.e., I'm not looking for simply
mydata %>% group_by(vs, am, gear, and carb) %>% summarise_if(...).
How can I calculate the means for a set of variables by
Displacement, then calculate the means for that same set of variables by
Horsepower, etc., then place in a table side by side?
I tried to come up with a reproducible example but couldn't. Here is a tibble from
mtcars that shows what I'm ultimately looking for (data is made up):
tibble(Item = c("vs", "am" ,"gear", "carb"), "Displacement (mean)" = c(2.4, 1.4, 5.5, 1.3), "Horsepower (mean)" = c(155, 175, 300, 200))