Log In
Register
Home
June 22, 2020
Offline
Hello,
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.
Thank you.
Best Regards,
Riste.
See Answer
July 16, 2010
Offline
Hi Riste,
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.
Mynda
Answers Post
1 Guest(s)
