Home > Blockchain >  Dynamic repetition of words of a cell
Dynamic repetition of words of a cell

Time:02-06

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.

target state

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.

now

How do I do that?

Here the link to the google sheet to copy and test: enter image description here

  • Related