Most people opt to do this manually, without realizing that Excel has a built-in feature called 'transpose' that'll do it for you. What if you want to swap the entire header column with the entire Salesperson column, while maintaining the integrity of the data in the spreadsheet?

You just need to highlight multiple rows or columns in the first step, and then follow the same procedure. You can swap multiple rows or columns using this same technique. The only difference is that you drag the mouse cursor to the side until the line after the column you want to swap with highlights with a dark line. If you want to swap columns instead of rows, you can highlight one column, and then follow the same procedure. When you release the left mouse button, the two entire rows will swap. With the Shift key still held down, drag the mouse to the upper edge of the John Hudson cell until the line just above that row highlights with a dark line. The mouse cursor will change to crosshairs. Hold down the Shift key, and move the mouse cursor to the top edge of the Julie Moore cell. Highlight the entire row with Julie Moore in column A. In this example spreadsheet, you can swap the Julie Moore row with the John Hudson row with just a few clicks of the mouse. If you want to flip to adjoining rows or columns, there's a useful mouse trick you can use in Excel to accomplish this. Now left click on row 2 and delete the numbered row. Since you highlighted all columns that contained data, all the data rows get flipped as well, so that everything lines up perfectly. Now you'll see that your entire first column is resorted with the cells in the header column flipped. Set Sort By to Row 2, Sort On to Cell Values, and Order to Largest to Smallest. Now follow the same steps to sort the table, but this time you'll sort by row rather than by column.Д¬lick Options, and select Sort left to right. You can actually use the same approach as above for flipping columns, with a slight variation.ДЇirst, add a new row just under the header, and number those cells from 1 (under January) to 12 (under December). What if you want to see sales data from December to January, rather than January to December? Now you have the same original table you started with, but with the entire column and data flipped bottom to top.

Now you can right click column A to select it, right-click Column A, and select Delete to remove the numbered column. This will not only flip the entire column from bottom to top, but it'll make sure all of the data in the rest of the spreadsheet swap to match the correct salesperson's name. Set Sort By to Column A, Sort On to Cell Values, and Order to Largest to Smallest. In the Home menu, select Sort & Filter from the ribbon.

This will autofill the rest of the column with numbers from 3 through 8. Double-left click the mouse to auto-fill the rest of the column down to the last salesperson's name. The cursor will change to two horizontal lines. Hold down the Cntrl key and place the mouse corner on the lower right corner of the cell with the number 2. Right-click column A, and select Insert to add a new column to the left of the Salesperson column you want to sort. It just means you need to follow a couple extra steps in order to use Excel's sort feature to flip the column. While there are lots of sorting options in Excel for organizing cells alphabetically, there isn't really a built-in option to simply flip a collection of random data, like names. If you want to rotate your data frequently to view it from different angles, consider creating a PivotTable so that you can quickly pivot your data by dragging fields from the Rows area to the Columns area (or vice versa) in the PivotTable Field List.These instructions apply to Microsoft Excel 2010, 1013, 2016, 2019, and Excel for Microsoft 365. 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. 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.

How to reverse transpose in excel