Cleanup Array of numbers?

[QuantEdge]

Hi excelers,
I am trying to clean up or re-order data multi-points on a array.
I need a formula to re-appear the "B" twice or 3 times base on C1 value.
I hope I have explained it well if not please see the example below or post me:
IF C1 = 3 then "B" will appear 3 times etc...

A1 B1 C1=2
................

. B
A B


. B
A B



. B
A B

...............

[jason.b75]

Having looked at some of your previous questions, I suspect that what you have asked for is far from what you actually need.

=T(IF(ROW(INDIRECT("1:"&C1)),"B"))

Array confirmed with Shift Ctrl Enter will give an array of B's based on the value in C1.