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)

How sellers can use AI to better engage with customers

Scheduling meetings, sending follow-ups, tracking conversation threads across both Outlook and Teams… Sellers are spending too much of their...

  • 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...
  • What is Bookings in Teams
      Watch Books in Teams video Bookings in Microsoft Teams lets you track, manage, and organize your team's appointments and calendars all...