I am using R studio to read a metadata file with multiple sheets. I’m trying to read 4 out of the 6 sheets into one file, but am failing to do so. Should be a simple enough problem. My friend suggested making a separate variable for each excel sheet and then using inner_join() to combine all into one spreadsheet, but I’m hoping to avoid all the unnecessary variables that come with that.

I am using R studio to read a metadata file with multiple sheets. I’m trying to read 4 out of the 6 sheets into one file, but am failing to do so. Should be a simple enough problem. My friend suggested making a separate variable for each excel sheet and then using inner_join() to combine all into one spreadsheet, but I’m hoping to avoid all the unnecessary variables that come with that.