Let's say that in Cells A1-A7 there are seven dates, and in Cells B1-B7 there are the number of rows you'd like per date.
From A9 downward, you'd like to list each date the number of times specified. For example...
• If Cell A1 contains "7/12/21" and Cell B1 contains "3", then Cells A9-A11 would all be "7/12/21".
• If Cell A2 contains "7/15/21" and Cell B2 contains "2", then Cells A12-A13 would all be "7/15/21".
• If Cell A3 contains "7/18/21" and Cell B3 contains "0", then this date would be skipped.
• And so on.
Is there a formula or formulas that can automatically generate these cells/rows? Thanks in advance!
From A9 downward, you'd like to list each date the number of times specified. For example...
• If Cell A1 contains "7/12/21" and Cell B1 contains "3", then Cells A9-A11 would all be "7/12/21".
• If Cell A2 contains "7/15/21" and Cell B2 contains "2", then Cells A12-A13 would all be "7/15/21".
• If Cell A3 contains "7/18/21" and Cell B3 contains "0", then this date would be skipped.
• And so on.
Is there a formula or formulas that can automatically generate these cells/rows? Thanks in advance!