I need an excel macro that can do the following:
The macro should evaluate a two-column table with columns labeled "Word" and "Frequency". The "Word" column will have a word value like "dog" and a frequency number like "5".
For each word,frequency row in the macro, the macro should output a line of text printing the word the same number of times as the frequency.
So for an Input row with word as "dog" and frequency as "5", the output would be:
dog, dog, dog, dog, dog;
The output must be in the same excel spreadsheet as the Input table. It must include the comma punctuation and the semi-colon at the end of each line.
Please see the attached photo for a sample of Input data and output for the macro.