Populating an array
 

I am trying to take a cell that contains a sum value and break it up into an
array of values. For instance, I have survey response in which the answers
range from Strongly Agree to Strongly Disagree. These answers have different
numerical values with Strongly Agree being 2, and Strongly Disagree being
-2). I know from my sum value that 188 participants strongly agreed to a
question. I am trying to take that 188 sum and break it down into a vertical
array of "2" copied 188 times.

I am completely lost on how to do this. Any help would be really appreciated.