Need help with Excel. Can you help?

Question

excel

Good afternoon everyone!
There is a table. The first sheet of the table is a continuous list of construction projects indicating the timing of implementation (quarterly) and their approximate potentials.
You need to somehow filter on separate sheets:
Sheet1: this year, projects quarterly
Sheet2: next year, projects quarterly
In the current version, the table is not applicable, because when you select a filter in any quarter of the year, rows in the other three quarters are hidden.
I ask for the help of experts. Thank you!
The table itself is in the mail cloud - https://cloud.mail.ru/public/4xuX/2pZp1fknv

Answer 1

Bring the data to a normal form, then make a pivot table and you can sort as you like.
Get something like this: