I have a question that seems similar to this one:
I want to sort the Rows on the 2nd Tab of the Spreadsheet ("Sorted Sheet"), so that the rows containing TIME (hours of the day) are sorted from earliest to latest (presumably A-Z).
Each TIME row is grouped with the 3 subsequent rows. This data (about 6 groups of 4 rows) needs to stay intact when sorted. All data needs to remain visible.
Is there a better/easier way to approach this task?
Please keep in mind: All the data on "Sorted Sheet" is automatically drawn from the 1st tab, which is a data-entry tab that will have lots of Data Validations and additional data that is pulled in from other sheets. So, it is ideal to to translate (transpose) it to "Sorted Sheet" with minimal changes in formatting. "Sorted Sheet" is only the 2nd (middle) step of this tool I'm making, so it might not make sense yet to criticize the whole endeavor.