How to dynamically add rows to a table

[d0rian]

I want a table that will dynamically adjust by adding rows when I update values. E.g. in the image below, if I change the values in B2 from 13 to 15, and in B4 from 2 to 8, I want the target table (in cols D:E) to automatically update to how it appears in K:L...The "Count" # represents how many rows of data I want for each label, so when I increase that value, I want the target table to automatically add the corresponding # of rows...

 

[ping_pong]

Two questions–

1. Is performance an issue? (Is the workbook large or slow?)
2. Any preference for formulas vs macros?

Edit: I lied, one more. How close to your real data is this example. Do you always have 4 dates? Do you have 5,000 sometimes? Thx

 

[d0rian]

Thx for follow-up; answer is that i much prefer formulas, and file is pretty bloated as is w/ a few sheets with 10,000 rows...but no need to think about further; i hacked together a workable version that does 80% of what i want. Thanks for reply tho!