How to sort a text table according to a pattern?

Question

Programming

I am not a real programmer, but in order to optimize the production process for creating reporting acts, the problem was solved using a macro, I wonder if it is possible to solve this problem in a more optimal way than 4 nested loops + 2 additional variables and 2 conditions, because this macro hangs other calculations in the book for me:
There is a monthly-daily schedule with a list of work for 1 year. For some types of work (this is known), it is necessary to prepare a standard act for hidden work every month (i.e., a data array of number of works * 12 closing periods) These works in the monthly-daily schedule can be entered out of order. There is also an array of links consisting of empty elements and the same types of work located within the sequence (there are no matches, each position is unique, if not, uniqueness is ensured manually by placing postfixes) as a result, within each month (column), the sequence of work performed was according to the array of links. How blocks of work will be located relative to each other is not important. If the works are connected, then the sequence of acts should go one after the other.
The question is, can this problem be solved using Excel formulas? If yes, where to dig?

Answer 1

Need to sort

"Data" tab, "Sorting" button block.

monthly-daily schedule with a list of works for 1 year.

Use instead of Excel Project , which is intended for this.