repeating data based on other data

i’m still relatively new to excel. i’ve been working 15+ hours on this sheet and figured there must be a faster way to do this. essentially, i’m recording words based on the number of “phonemes” (sounds) it has. (ex. “boy” has two: ‘b’ and ‘oi’). anyway, i have all the data of how many phonemes each word has, but i need to repeat a word several times based on the number of phonemes, so in this case, i would write “boy” twice over two rows. i was wondering if there was some kind of formula ?? code ?? that would do this for me.

 

Thanks!

By: catherine

Leave a Reply

Your email address will not be published. Required fields are marked *