I have collected data from crowd-souring platform where I asked each subject to enter three short stories. Then I calculated some text metrics. The data about the subjects like age, gender is repeated.

Please see the sample variables. The variables in BOLD are repeated.

Worker ID, Story, Category, Trigger Devices, Triggers, Action Devices, Actions, Word count....... smart home exp.,Gender, Age, Family Size, Originality, Practicality, creative (binary). Now you can imagine how my excel sheet will look like?

Could you please help how to deal with this problem and which tests you would recommend to me?