I have a Google form we use to record raffle entries for a cat rescue. Supporters enter by adding a Facebook comment with how many entries they want then one of the rescue’s volunteers adds them to the form - name and number of entries.
Is there then a way to get Google Sheets to automatically duplicate each entry (name) for as many times as the number of entries given in the form?