Need to easily alter your data in Excel? Rotating rows into columns, or vice versa, is a incredibly useful function! It's far less complicated than it sounds. Simply choose the area of values you want to modify, then head to the Edit tab and press the “Switch Rows/Columns” button. And that’s it! Your figures is now presented in a new format�