Transposing in Excel – How it Works 2020!

Transposing in Excel – How it Works 2020!

Have you tried copying and pasting from an external data source into Excel? A lot of data has already been found and by this point you will have typed each value manually .But it doesn’t have to be! In addition to the simple copy function, Excel also provides the option to sort non-formatted data sets. We explain how to transfer data in Excel.

Excel: Transposing2020

When you copy values ​​from a poorly formatted data source into an Excel spreadsheet, the results can be quite useless. Instead of dividing everything neatly into rows and columns,Statistics, for example, are entered permanently below the last entry -With all entries in just one column. It may take a while to set it up by hand later
However, Excel also allows you to move data and split it into columns.

First copy a dataset – that is, all the values ​​that are together -In the clipboard. In the Excel document, then right-click on the cell of your choice and select “Transpose”. The contents of the cell are no longer arranged under one another They are with each other. This step is repeated for all data sets and therefore can bring all the data in the desired order. This saves a lot of work. However,

If you need to bring a large amount of data in a new order, it is better to use formulas for this purpose.

To make things a little easier, you can also copy, paste, and transpose by using shortcuts:

  1. First, you mark the data area. (If the individual data sets are separated by blank rows, you can also use the combination Ctrl + Shift + *).
  2. Then copy the marked area with Ctrl + C.
  3. Navigate to the area where you want to insert the data, and then press the keyboard shortcut Ctrl + V to insert the data.
  4. Press 2 x Ctrl to activate the required context menu.
  5. With the T key, activate the transpose function.

Transpose by Formula: TRANSPOSE 2020

If you want to transfer data to Excel, you can also use a special function. Transpo allows you to fully configure the table  It’s a row formula – a formula that applies directly to many, not just one cell. To do this, you must first mark a free area the size of the table you want to move. If the table actually has 10 rows and 3 columns, select an area with 10 columns and 3 rows.

While the cells are still selected, write the TRANSPOSE function:


Array refers to the area you want to transpose. So, if the sample table is in the cells from A1 to C10 (top left cell and bottom right cell), specify the range A1:C10. The double point acts as a kind of to-sign.

The function is not confirmed – as is usual – with the Enter key. Instead, press the key combination Ctrl + Shift + Enter. Now you have a new table with the required sorting.

Leave a Reply

Your email address will not be published. Required fields are marked *