Tag Info

New answers tagged


By default, your chat list will be sorted by the people with whom you communicate most often. However, you also have the option of changing to alphabetical sort order. In Gmail: Click Options from the bottom of your chat list. Under Show in chat list: click All contacts or Top 250. You can change this back to popularity by selecting Most Popular instead. ...


The formula =TRANSPOSE(QUERY(A:A, "select A where A contains '1.'")) entered in C2, would fill C2, D2, E2 with 1.1, 1.2, 1.3, as in your example. You can also include a formula within the query so it's applicable to every row in your example: =TRANSPOSE(QUERY(A:A, "select A where A contains '"&ROW()-1&".'"))

Top 50 recent answers are included