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