Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In a Google Spreadsheet I have different groups of cells in one column to auto-sort. All cells in this column have same pattern of data, all datum have it's own cell and it's needed to be sorted into six or seven rows.

enter image description here

There is no need to change data in any way, just to sort it.

I have a solution for small range using hardware macros, under 500 cells (and it was basically a legwork done by programmed keyboard), but now I face data ten time the size.

Can It be done?

share|improve this question
So, in short, you want to sort a column into different columns according to the scheme you presented? – Jacob Jan Tuinstra Sep 2 '13 at 5:25
Yes, that's pretty much the problem. Any ides? – user46797 Sep 3 '13 at 11:42
I think you mean transpose (by group) not sort. Does each group start with exactly the same number of rows as every other (3 in your example)? – pnuts Feb 16 '14 at 16:13

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&".'"))
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.