February 17, 2020
Excel Tip: Transpose Data
Flip your data with transpose
- Highlight the data range
- Copy the data
- Right Click on the cell where you want to paste the data
- Choose Paste special (use the mouse to paste special)
- 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)
hello