Data is Fun

Where data is fun.


February 17, 2020

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)

Leave a Reply

Your email address will not be published. Required fields are marked *