View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kalik00 kalik00 is offline
external usenet poster
 
Posts: 1
Default generating list of data from frequencies

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?