Thursday, September 17, 2020

Using Transpose Function in Excel 2016

 The TRANSPOSE Function 

The Transpose function will shift a vertical range of cells to a horizontal range and the reverse. To operate correctly, this function needs to be entered as an array formula in a range that has the same number of rows and columns.   

 

For example, suppose that you wanted to transpose the values in column A so that they appear horizontally on row 1:  

 

 

 

To do this, first select the destination cells that you would like the results to be shown in:  

 

 

 

Next, you would enter the transpose function into the Formula Bar with the original cell range as the argument – in this case it would be “=TRANSPOSE(A1:A5):  

 

 

 

Press Ctrl + Shift + Enter to enter this function as an array formula and the results will be displayed within the selected cells:  

 

 

 

 

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

9 Shortcut Tips for Copilot with Microsoft 365

By incorporating these shortcut tips, you can make the most out of Microsoft 365 Copilot and enhance your productivity. If you have any spec...

  • PowerApps: Canvas vs Model Driven
      Both  Canvas Apps  and  Model-driven Apps  have some similar components to their design. Although there are many differences between the t...
  • Creating Webinars in Microsoft 365 Teams
      Create Webinar in Teams Video How webinars are different from ordinary meetings Ordinary meetings generally include a lot of back-and-fort...
  • Dynamics 365 Business Central Tip
    Users can personalize and customize how Dynamics 365 Business Central looks. There are fields that are hidden and shown by default. With Per...