Fandom

How To Wiki

How to transpose a data array in Microsoft Excel

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

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.


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.

Also on Fandom

Random Wiki