Filter table by pattern

Question

Here is my spreadsheet. I need to display data from the range A1:J11 as in the example M1:O16. Is it possible to implement this with a formula? I will be glad for any help.

Added:

I have a spreadsheet where data is added daily in a format such as the range A:J. I need to form a table from this data on another sheet, in which the first column will contain DATE, the second column will contain data for the DAY, and the third column will contain data for the NIGHT. As in the example of M1:O16

Answer 1

try:

={QUERY(FLATTEN(QUERY(A1:J; "skipping 4")); "where Col1 is not null"; )\
 QUERY(FLATTEN(QUERY(FILTER(A3:J; MOD(COLUMN(A:J)-1; 2)=0); "skipping 4")); "where Col1 is not null"; )\
 QUERY(FLATTEN(QUERY(FILTER(A3:J; MOD(COLUMN(A:J);   2)=0); "skipping 4")); "where Col1 is not null"; )}