How to put the hurdle items and names of Table 1 in column I and J

[choletseng]

Help merge repetitive sorting formula
Item and name cannot be duplicated
From Table 1 To Table2


Can someone please help me ? It would be much appreciated. Thanks in advance

[Bo_Ry]

Please try

=SORT(UNIQUE(CHOOSE({1,2},FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,REPT(A2:E20,B1:F1="Name"))&"</m></x>","//m"),FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,REPT(B2:F20,B1:F1="Name"))&"</m></x>","//m"))))

or

=SORT(CHOOSE({1,2},FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,REPT(A2:E20,B1:F1="Name"))&"</m></x>","//m[not(preceding::*=.)]"),
FILTERXML("<x><m>"&TEXTJOIN("</m><m>",,REPT(B2:F20,B1:F1="Name"))&"</m></x>","//m[not(preceding::*=.)]")))

[choletseng]

Problem solved, You are great

Bo_Ry Thanks you very much