Filter problems

[Maci3j]

Dear Readers,

I would like to simplify my sheet. When i will filter the table by QA6 for example 1a, I would like to see all systemnames. This without copying the 1a to all cells left to the systemname. How can I assign or connect the 1A cell to all systemnames of 1A (012fb001, 012fb002, 012fb003, 012fb004).
Down below you can find an example of my table.
Thanks in advance for your help.

QA6	Systemname
1a	012fb001
	012fb002
	012fb003
	012fb004
2a	018vv001
	018vv002
	018vv003
3a	020bb001
	020bb002
	020bb003
	020bb004

<TBODY>
</TBODY>

 

[RonB1111]

If QA6 is a header name in cell A1, and systemname in B1 with data beginning in row 2, enter any header name such as QA6-2 in cell C1 and enter this formula in C2 and copy down:
=IF(A2="",C1,A2)
Now do your filtering on QA6-2.