|
|
|
|
How to sort data in Google Drive Spreadsheet
After you've entered fields into your pivot table report, you can sort, summarize, filter, or add formulas to the data contained in your pivot table report. Let's learn about several ways of sorting data.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2.
|
|
|
Click CREATE and select Spreadsheet.
|
|
|
3.
|
|
|
Enter any data. You can copy mine.
|
|
|
4.
|
|
|
Select all data in column A.
|
|
|
6.
|
|
|
…and select Sort range.
|
|
|
7.
|
|
|
In new window select A – Z. Click Sort.
|
|
|
8.
|
|
|
Data has sorted in alphabetical order.
|
|
|
9.
|
|
|
Now select all data in both columns.
|
|
|
10.
|
|
|
Click Data and selcet Sort range by column A, A – Z.
|
|
|
11.
|
|
|
In this case, data in first column had advantage in the distribution. If we would start selecting in second column, the advantage in the distribution would have data in the second column.
|
|
|
|
|
|
|