I have an excel file created from a form filled by a few thousand people. This form has a couple of questions and one of these questions have more than 60 possible answers. The person filling the form can choose 1 to 60 from a list. Let's assume I give this column the title "Community". There are currently nearly 1500 people who filled the form. Some of them have chosen one community while others several communities, and if the person has chosen several communities, they are listed in cell associated with that column separated by a comma like this:

Column A (Timestamp) | Column B (email) | Column C (Yes or No) | Column D (Community)|Column E (Name Surname) | Column F (Cell Phone) | GHIJKLMNO (other answers)



Community

a

d

a, b, d

c, f

a, b, c, d, e, f

...



I want to achieve this:



Create a new excel file for each community (currently more than 60) that can be chosen in question "Community".

So newly created excel files should have the following filenames:

A Club

B Club

C Club

...

I want only information of the people who have chosen A Community to be included in the new excel file named "A Club", but I also want people who have chosen A community and also other communities to be on this excel file. (I want rest of the cells in rows for that person left intact). I also want the have the first rows containing titles to be on top of each new excel file. I also would like the newly created excel files to be converted into tables (with first row being titles)



Can someone guide me step by step how to create something (maybe a script) which does all of these with a single click so that someone old who doesn't know how to do this by filtering can do this?



After the excel files are created, I want them to be sent to a google drive and only the manager of that community should be able to download that file)