Drop down list/multi select

I hope this doesn't sound to complicated, but I'm trying to find an easy way to collect some data, and would appreciate any assistance. If I have a spreadsheet with 200 employees listed, and am polling them with 20 questions (yes/no) is there a way to either create a drop down for each employee and check either yes or no for each question or is there another way that might be easier?

I did look into the survey options briefly but the issue I'm having is asside from the questioner I have 15 comluns with employee info. Name, birthdate, favorite restaurant, pets etc, so I wanted to keep everything in one sheet if possible. Could I some how list the 20 questions with a yes/no answer but make it so each column only shows 1. Yes, 2, no ect in a drop down for each employee?

A sample file would help here thanks

Sorry. Im new to this site. That would be a good idea huh? I tried but am having a hard time. Not sure if its my PC or not. Will try again later on.

Go to Advanced and click the paper clip and then follow screen instructions

Thanks

I did that, but then then the circle keeps spinning and didn't upload. I will try from another PC in a little bit. Sorry about that.

Hopefully this worked...All about me.xlsx

Hi,

Can you post a before and after workbook? I am having some issues understanding what you want to accomplish.

Thanks