This Is a Very Useful Function in Google Sheets But Not Many

If you've ever been familiar with spreadsheet tools such as iWork Numbers, Zoho Sheet or Open Office Calc and especially Microsoft Excel, you will find quite a lot of similarities with Google Sheets, especially in the names and uses of the calculation functions.

Like Excel, in Google Sheets, there are many specialized spreadsheet content sorting functions that are extremely useful in situations, but rarely used because not many people really know, especially for For those who do not often work with these spreadsheet tools, a good example is the TRANSPOSE function .

When working with Sheets, there are times when you need to convert a column into a row or convert a row of data into a column, of course, retyping 'manually' will take time, so remember the TRANSPOSE function., As follows.

For example, we have 1 original data table as follows:

Now or add a new sheet, enter the following formula in cell A1 and press enter:

= TRANSPOSE (Sheet1! A1: C6)

Replace part 'Sheet1' with the name of the sheet containing the original data sheet.

The new data table will appear as below:

Done, so you can convert the data from a column table into a successful row, otherwise you can do the same. So with a very small trick, we can save a lot of time and effort in data conversion already!