Expanding Meals Count on each date

[Sameer_Kuppanath_Sultan]

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? 

[#2 · Accepted solution]

@Sameer_Kuppanath_Sultan 

See the attached version for a solution using formulas.

I also modified the formulas in Table 1 slightly.

[#3]

@Sameer_Kuppanath_Sultan 

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)

[#4]

Excellent!