Write "Text" in the number of rows listed in a cell

[WhatTheF]

I'm trying to find a formula that will generate an array of rows with a text string in them based on the number in a cell. So, if A2 has the number 12 in it, and I input the formula in B2 it will populate B2:B13 with whatever text I've asked. In my example, it would be "Virginia Opossum."

Report Informatino Generation.xlsx
	A	B	C
1	Total Number of Patients	Species
2	12
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17	Text to input in yellow cells, "Virginia Opossum"
18
19
Sheet8

Thank you, again!

 

[FormR]

Hi, here's one option you could try.

Book2
	A	B
1	Total Number of Patients	Species
2	12	Virginia Opossum
3		Virginia Opossum
4		Virginia Opossum
5		Virginia Opossum
6		Virginia Opossum
7		Virginia Opossum
8		Virginia Opossum
9		Virginia Opossum
10		Virginia Opossum
11		Virginia Opossum
12		Virginia Opossum
13		Virginia Opossum
Sheet1

Cell Formulas
Range	Formula
B2:B13	B2	=IF(SEQUENCE(A2),"Virginia Opossum")
Dynamic array formulas.

 

[WhatTheF]

=IF(SEQUENCE(A2),"Virginia Opossum")

This works PERFECTLY! Thank you, sir! (After 14 hours of starring at that stupid workbook, my brain was FRIED! I appreciate your help!

-Mathis