Are you still using Ctrl + C and CTRL + V? These two transpose methods help you increase the efficiency by 80%!

An example of converting a row into a column in Excel is particularly common. The following two methods can help you solve the 99% row and column transpose problem!

Click "follow" in the upper-right corner of the article to encourage you. Thank you!

Let's first compare the following two images:

As more and more tables are named, it becomes more and more troublesome to view them.

 

The following table shows that it looks quite comfortable. This is also the way we create tables.

 

By comparison, we know which image is what we want. But sometimes the tables that others send to us are not what we want, and the data size is large. What method should we use to convert them into what we want?

Method 1: select Paste"

Step: select the data area-Press the shortcut key "Ctrl + C" to copy-Right-click a blank cell-select and paste-transpose ".

 

Animation demo:

 

Method 2: Use the transpose function "transpose"

Step: select a cell area to display the result (A8: F16) -- enter the formula "= transpose ($ A $1: $ I $6) in the editing column) "-- press the shortcut key" Ctrl + Shift + enter.

 

One disadvantage of this method is that the generated region cannot be directly modified. The generated data is changed only when the original data is changed.

Are you still using Ctrl + C and CTRL + V? These two transpose methods help you increase the efficiency by 80%!