How to create a dynamically shaping Google Sheets range?

Question

Google Sheets

Straight to the point: Sheet 1
has 3 columns with a dynamic range
2 conventional text columns (customer, tasks)
1 numeric column (hours spent)

What are the options to make a final table on Sheet 2 that will form data in this form

Answer 1

How to create - take and create) as well as in any tables aka Excel
1. Write logic with formulas
2. Write logic with scripts