Return value based on the fact if cell is full or not

Hi,

Please see screenshot before description:

Capture.PNG

I have prefilled Month column but instead of manual prefill, it should hold formula/solution. The solution should look at the lower table and see, that for jan column there are two values, so jan needs to repeat twice in the upper table and so on for the rest of the months. How to do it?

In the beginning I was thinking of using approximate HLOOKUP. Count the values in each month's column and add result to the previous column. So the value for jan would be 2, for feb ir would be 3 because 2+1=3. Then along the month column of upper table have and "index" column that is used as "what to hlookup column" and based on approximate match, find value. That doesn't work though because two things: I don't know what to do with "empty" month in the lower table and if index column from 1 to whatever holds a number that isn't in the list of values for lower table, it will still be looked up based on approx. match which is the solution and the problem at the same time.

It is impossible to see what is where from a picture. In the absense of a sample workbook, I've had to make a few assumptions.

With 'Jan' in the bottom table in your picture located in I1 (so 40 for May would be in M2), enter the following formula into A2, then fill down

Formula:

Please Login or Register  to view this content.

and this one in B2, then fill down

Formula:

Please Login or Register  to view this content.

I would look at the below link and adapt
https://www.extendoffice.com/documen...e-x-times.html

use hlookup instead of vlookup

Thank you to both answer posters! The second solution is along the lines of my thinking, just couldn't figure out the details.