Fandom

How To Wiki

How to transpose a data array in Microsoft Excel

1,797pages on
this wiki
Add New Page
Talk0 Share

Microsoft Office

Microsoft Excel

  • Copy the array
  • Click on empty part of the spreadsheet, where the transposed data will fit
  • Right Click on the area you have chosen
  • Click paste special
  • Check the transpose checkbox
  • Click OK, and it should work


    From HowTo Wiki, a Wikia wiki.

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.