Verify these formulas use absolute references-if they don’t, you can switch between relative, absolute, and mixed references before you rotate the data. If your data includes formulas, Excel automatically updates them to match the new placement. Īfter rotating the data successfully, you can delete the original table and the data in the new table will remain intact. Right-click over the top-left cell of where you want to paste the transposed table, then choose Transpose. The new table that you paste there will entirely overwrite any data / formatting that’s already there. The earlier answer using as.data.Note: Ensure that you copy the data to do this, since using the Cut command or Ctrl+X won’t work.Ĭhoose a new location in the worksheet where you want to paste the transposed table, ensuring that there is plenty of room to paste your data. The smiths data will not give that warning because all columns except for subject are doubles. This is related to converting columns with different attribute types into a single character column. Using the example starting_df with the tidyverse approach will throw a warning message about dropping attributes. Using the tidyr::smiths sample data would be: smiths %>% If there are no meaningful row names you can skip rownames_to_column() and replace rowname with the name of the first column in the dataframe, assuming those values are unique and meaningful. Rownames_to_column() is necessary if the original dataframe has meaningful row names, otherwise the new column names in the new transposed dataframe will be integers corresponding to the orignal row number. Here is a tidyverse option that might work depending on the data, and some caveats on its usage: library(tidyverse)

Excel rotate row to column