How do I turn tables in Excel to switch columns to rows and vice versa?
Have you found yourself in a situation where you had a table of data in Excel that you needed to switch columns to rows and vice versa? There's no need to re-enter all that data. What you need to do is transpose your data. Here's a Paste Special trick that will solve your problem in no time.
- Select the range of cells you need to transpose.
- From the Menu Bar, select Edit -> Copy.
- Select a cell where you want your new transposed data to start.
- From the Menu Bar, select Edit -> Paste Special and place a checkmark in the Transpose box at the bottom of the window.
- Click OK.
You may find that you have to do some minor formatting, such as adjusting column widths, to get everything looking perfect but you have just saved yourself a whole lot of work!