Multiply Text Cell to Multiple Outputs

**NewMediAroused** · 04-06-2009, 02:23 PM

I have a worksheet that is full of text cells in Column A and numbers in Column B. Column B represents the number of occurrences of the adjacent text in Column A for my data set. For instance below, KEYWORD A occurs 5 times and KEYWORD B occurs 3 times in the data. How can I get Excel to essentially expand this number of occurrences? So for KEYWORD A it would look at the number 5 in column B and give me 5 cells with KEYWORD A in them?

KEYWORD A 5
KEYWORD B 3

KEYWORD A
KEYWORD A
KEYWORD A
KEYWORD A
KEYWORD A
KEYWORD B
KEYWORD B
KEYWORD B

**zbor** · 04-06-2009, 02:29 PM

try

Please Login or Register  to view this content.

where is A1 first word and A6 second

**NewMediAroused** · 04-06-2009, 02:32 PM

Ok, so for this does there need to be sufficient empty cells between the two keywords to fill them out? So KEYWORD A occurs 5 times, there need to be 5 empty cells between KEYWORD A and KEYWORD B?

**zbor** · 04-06-2009, 03:03 PM

Try this in B column (B1 is first formula, B2-Bxxx is second)

=A1
=IF(COUNTIF($A$1:B1;A1)>1;"";A2)

**NewMediAroused** · 04-06-2009, 03:27 PM

Thank you for your help. I don't think I am explaining the problem very well - maybe this attached example sheet will help? Column B has numbers is in it that I want to multiply by Column A. The end result should take up as many cells as the number in Column B.

I am so sorry that I'm not very good at explaining it.. Thank you again for being so helpful!