picture

picture

Mid-Year Promotion Offer, Life Membership Discount 70 Yuan 

picture 【Unlock Member】picture 

Support WeChat public account + applet + APP + PC website multi-platform learning

pictureFunction TRANSPOSE: Returns the transposed range of cells.


Use format: TRANSPOSE(array)

1. Basic usage


picture


The data area A1:D7 is a cell area with 7 rows and 4 columns, so you need to select an area with 4 rows and 7 columns to store the transposed data.


Select the range of cells A10:G13
Enter the formula: =TRANSPOSE(A1:D7)
Press <Ctrl+Shift+Enter> three keys to end.
picture
Note: There are a pair of curly braces {} at both ends of the formula, this is not entered manually, but by pressing <Ctrl+Shift+Enter> three keys.
picture
The basic usage of the function TRANSPOSE is very simple, that is, to transpose data. Then let's take a look at the combined application of the function TRANSPOSE and other functions.

2. Combined application of functions TRANSPOSE and HLOOKUP
Find the corresponding performance according to the salesperson:
picture
For vertical search, the first thing that comes to mind is to use the function VLOOKUP. In fact, the function HLOOKUP can also be used to search vertically, but with the help of the function TRANSPOSE.
picture
Enter the formula:
=HLOOKUP(D2,TRANSPOSE(A2:B7),2,0)
Press <Ctrl+Shift+Enter> three keys to end.
The TRANSPOSE(A2:B7) part transposes the data in the vertical direction to the horizontal direction;
Then use the function HLOOKUP to search in the horizontal direction.
3. Combination of functions TRANSPOSE and MMULT
Summarize the data in the table on the left of the following figure into the table on the right:
picture
Seeing this question, some children's shoes will say that using pivot tables is very simple, just drag and drop! Today we are talking about the function TRANSPOSE, we must apply what we have learned and use the combination of the function TRANSPOSE and MMULT to solve it, so how to write the formula?

picture
Select the range of cells F2:H5
Enter the formula:
=MMULT((E2:E5=TRANSPOSE(A2:A15))*1,(B2:B15=F1:H1)*C2:C15)
Press <Ctrl+Shift+Enter> three keys to end.
That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.
      
     
            
     
   
          
      
     
            
     
   
          
      
     
            
     
   
          
picture

picture
picture
★ FAQ ★ 
①Xiao Ai: Can you watch all the courses after buying VIP ?
Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)

②Xiao Ai: Hello, how do you study ?
Pay attention to the Aizhiqu Education service account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!
Computer login to https://www.92zhiqu.com
(Mobile phone, computer learning is essential)

③Xiao Ai: what to do if you do n’t understand
Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)

④Xiao Ai: Provide video courseware materials ?
Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)

⑤Classmate Xiao Ai: Validity period of study ?
Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)

⑥ Primary school students: Does the website support accelerated viewing ?
kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback

⑦ Does the course support offline download ?
kindness. Both Android and Apple IOS APP support mobile phone offline download
Computer downloads are provided by contacting WeChat customer service 18074746783.

⑧ How about the quality of the course ?
Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition

pictureIf there is anything else you need to consult, please contact WeChat customer service 18074746783
Long press to identify the QR code "Add Customer Service"
picture
pictureClick to read the original text , log in to the official website with one click, and learn from a large number of video VIPs! (you can try it out)