title: Excel filtering for merged cells
body: <p>I'm trying to make a calculation of hours worked for each employee on each project that he worked on. But i don't know how to select because the cells that are containing the name of the employee are merged like in the picture. And if i want to see on project no. 3 which are the employees that worked on, the Excel Filtering can't take the name &quot;John&quot; which corresponds only to project no.1. To be more clear, I need to know how the filtering will be made for cells A3 and A4.
  If i will unmerge the cells, John will be only on cell A2, and in fact he worked also on projects 2 &amp; 3.</p>
  <p>Thanks!</p>
  <p><img src="https://i.stack.imgur.com/zyQgz.png" alt="Excel screenshot" /></p>