When you select the second row of table 1 and apply Advanced Filter, check the unique records box and choose your destination where you want the result to be copied to. Result will be transposed, so transpose it back. Delete all unwanted data.
If you do all that while recording a macro, you can simply run the recorded macro to filter again.
But I've got a feeling I'm misunderstanding you. If I did then please explain in greater detail.