Jul 24 2021 11:30 PM
Hi All
I have a set of data here down below in table 1. (Attached the excel too)
I want to prepare Table 2 based on the date in table 1. ie., I want to expand the data from Table 1 based on from date to end date and meals count in these days (Breakfast, Lunch and Dinner).
Is there any particular formula/ power Queries to do this?
Jul 25 2021 03:47 AM
SolutionSee the attached version for a solution using formulas.
I also modified the formulas in Table 1 slightly.
Jul 25 2021 08:32 AM
With everyone's permission, if I may add a simple formula in addition to the elegant solution proposed by Mr. Hans Vogelaar (@Hans Vogelaar).
=SUMIF($D$3:$D$21,$M3,$H$3:$H$21)+SUMIF($F$3:$F$21,$M3,$H$3:$H$21)
File is inserted.
If the simple suggested solution helps you, I'll be happy, if not please just ignore it :).
Thank you for your understanding and patience
Wish you a nice day.
Nikolino
I know I don't know anything (Socrates)
Jul 25 2021 03:47 AM
SolutionSee the attached version for a solution using formulas.
I also modified the formulas in Table 1 slightly.