The columns have multiple variables, such as the year, the IEA grouping, and the onshore and offshore status. how can i get all of these variables to be their own column and make the data set taller?
Im fairly new R and am somewhat familiar with melting and casting a messy data set but idk how to approach this kind of problem.
basically i would like to have a column for each of the current column variables, which would necessitate way more rows but would make the data much easier to work with.this is the top right corner of the data set. as you can see, each of the columns currently have 6 different variables, and i would like each to have their own column
