1.

How Can You Transpose A Data Set In Excel?

Answer»

There are TWO POPULAR WAYS to transposing data in Excel:

  • Using Paste Special dialog BOX.
  • Using the Transpose Function.

With Paste Special dialog box, you need to first COPY the data that you want to transpose, select the cell where you want to paste it, right-click and go to Paste special, and select the Transpose option.

There are two popular ways to transposing data in Excel:

With Paste Special dialog box, you need to first copy the data that you want to transpose, select the cell where you want to paste it, right-click and go to Paste special, and select the Transpose option.


Discussion

No Comment Found

Related InterviewSolutions