Tag Info

New answers tagged

2

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. ...


0

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