filter multiple rows

[Chomper]

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?

 

[NeonRedSharpie]

Have a column in front of it all that includes the formula:

=IF(B2="Target",B1,B2)

And copy it down. Then you can filter on that.

 

[Chomper]

thanks