Can you summarize by names found in either column?

1

I have all my data joined together and now I want to summarize it by counting the number of times a person's name shows up. The problem is that their name could show up in column A or column B. Is there a way to do that summary?

Thanks for your help!!!

2

Hi @paintbb84
Yes, using Custom Column to concat([a], [b]):
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#creating-custom-columns