Table TB1
Name name number surgery title number
Zhang SAN A001 surgery A 1
Zhang SAN A002 surgery 2 B
Zhang SAN A003 surgery 3 C
Zhang SAN A004 surgery 4 D
Zhang SAN A005 surgery 5 E
Li si A001 surgery A 1
Li si E A005 surgery 2
Fifty and A001 surgery A 1
Chen six A005 E surgery 1

Conversion results is (surgery needs is more than 4, need not displayed)

Name surgery 1 number 1 name surgery 2 number 2 name surgery 3 number 3 name
Zhang SAN A001 surgery A A002 surgery A003 B C
Li si A001 surgery A A005 E
Fifty and A001 surgery A
Chen six A005 surgery E

Thank you for your guidance!