June 22, 2020
I need help with an excel file that I make.
The client requested: based on the number of entered "causes" in the first sheet, the "problem/process" to be automatically filled that number of times in the second sheet.
For example, in the first sheet I have Problem 1 with 2 causes. And in the second sheet, Problem 1 to be filled in 2 rows automatically.
Please find the excel file attached, so that it is more clearer.
July 16, 2010
I don't recommend using a formula for this task. In fact, I recommend you change the structure of the Plan sheet so that it's in the same format as the Do sheet. i.e. a Tabular layout.
Alternatively, you could use Power Query to unpivot the data in the Plan sheet and place it on the Do sheet. In the attached file you can see the query output on the sheet called 'Table1'. You can further modify the query to suit your needs.
I hope that helps.