How often have you typed your data in and then wished that it was presented differently? The good news is that it is extremely easy to flip or transpose your data.
In the spreadsheet to the left, I have sales for each salesperson by month which is pretty standard way to set up your data. But, I wonder if the data might be more useful if it was presented by month for each salesperson. Rather than retyping or dragging everything around, you can use the Paste Special command and transpose all the data at once.
Here is how to do it.
- Select the data. In this case A3.G12
Voila- Your data is flipped!