Name | Cash | Fixed Inome | Cdn Eqty |
Client 1 | 35% | 13% | 52% |
Target | 10% | 30% | 60% |
Client 2 | 38% | 16% | 46% |
Target | 10% | 30% | 60% |
<tbody>
</tbody>
I have an excel sheet that shows the client data on one row and their corresponding targets on the next row down. Is there a way to link the two rows together so I could use the filter function (on a column) without losing data integrity?