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?

  • So, in short, you want to sort a column into different columns according to the scheme you presented?
    – Jacob Jan
    Sep 2, 2013 at 5:25
  • Yes, that's pretty much the problem. Any ides?
    – user46797
    Sep 3, 2013 at 11:42

1 Answer 1


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&".'"))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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