Hi there I build a database in Google Sheets and have the following problem. I have three values: Date, employee and task. In the end I need for all combinations one line.
Goal:
Because the number of employees and tasks can change by time, I need to build this by formula.
The only missing formula is in the red cell, which repeats the tasks as many times, as there are employees. So every employe has each date with each task.
How do I do that?