Hi I have a list of companies where there are up to 3 founders in each with their own demographics all in the same row. I am looking for a way to analyze the demographics of each company by person. So for instance I want to know if the company has a female founder or a female black founder etc. There are 1000s of companies so Im looking for a way to do this at scale. Do you have any ideas? I was thinking I could do If statements but due to the endless possibilities I need to analyze this could take a while? (Because I’d have to create an if statement for each possibility – example, if f4=female and g4=black or if h4=female and , if i4=black, etc) 

​Hi I have a list of companies where there are up to 3 founders in each with their own demographics all in the same row. I am looking for a way to analyze the demographics of each company by person. So for instance I want to know if the company has a female founder or a female black founder etc. There are 1000s of companies so Im looking for a way to do this at scale. Do you have any ideas? I was thinking I could do If statements but due to the endless possibilities I need to analyze this could take a while? (Because I’d have to create an if statement for each possibility – example, if f4=female and g4=black or if h4=female and , if i4=black, etc)   Read More

​