This is a very useful function in Google Sheets but not many people know it

Google Sheets is an extremely flexible and useful online spreadsheet tool, combining settings and calculating data in spreadsheets. Google Sheets supports many interactive functions, automatic data collection, even pulling data from third-party APIs. From budgeting, tracking investments, to project management and data analysis, Google Sheets can be used for a variety of tasks.

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:

This is a very useful function in Google Sheets but not many people know it Picture 1

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:

This is a very useful function in Google Sheets but not many people know it Picture 2

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!