Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

Your Answer


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

Browse other questions tagged or ask your own question.