Need to quickly alter your figures in Excel? Transposing rows into columns, or vice versa, is a incredibly useful feature! It's considerably simpler than it sounds. Simply select the range of values you want to transform, then head to the Insert tab and press the “Switch Rows/Columns” button. Voila! Your figures is now shown upside down—helpi