How to create dynamic excel files from a list of data in a column

I have tried to follow this link: as it is relevance to what I am trying to do Creating Dynamic Excel Sheet Based on a Column - #4 by Hiba_B