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