Data is Fun

Excel Tip: Transpose Data

Flip your data with transpose

1. Highlight the data range
2. Copy the data
3. Right Click on the cell where you want to paste the data
4. Choose Paste special (use the mouse to paste special)
5. Click on Transpose

Let’s See it in action:

(Note: there is also an Excel Function =TRANSPOSE(), That does the same thing but via formula)