generating list of data from frequencies

[kalik00]

I have a frequency matrix for numeric categories. Some of the frequencies are
very large (1000s) and I want to generate a list of data with the category
value repeated the number of times it occurs in the data set (i.e. if "5" is
category and frequency is 1543 then I want 1,543 "5"s in a column. Any ideas?

 

[Sheeloo]

If your category is in A1 and frequency in B1 then enter this in C1
=REPT(TEXT(A1,"@"),B1)
and copy down... It will work subject to maximum characters in a cell.

 

[Sheeloo]

From Excel HELP

The result of the REPT function cannot be longer than 32,767 characters, or
REPT returns #VALUE!.