What is the best practice to switch the columns and rows in a range?
A)Cut the range, then use the Paste Special option called Values
B)Cut the range, then use the Paste Special option called Transpose
C)Cut the range, then use the Paste Special option called Switch
D)Cut the range, paste it into a blank area, then cut and paste each cell where you want it

Question

Quizplus · Accepted Answer

The best practice to switch the columns and rows in a range is to use the Paste Special option called Transpose. This will allow you to simply cut the range, then paste it back with the rows and columns switched.

What Is the Best Practice to Switch the Columns and Rows