On the SHIP1 tab, enter the following into cell X20.
=IF(K20=U$20,V$20,"")&IF(K20=U$21,V$21,"")&IF(K20=U$22,V$22,"")&IF(K20=U$23,V$23,"")&IF(K20=U$24,V$24,"")&IF(K20=U$25,V$25,"")&IF(K20=U$26,V$26,"")&IF(K20=U$27,V$27,"")&IF(K20=U$28,V$28,"")&IF(K20=U$29,V$29,"")&IF(K20=U$30,V$30,"")&IF(K20=U$31,V$31,"")
Then select cells X20:X31 and hit Ctrl-D.
Enter the following into cell U43.
=IF(LEFT(V33)="E",U33&CHAR(160)&REPT("▢",W33)&"│ ","")&IF(LEFT(V34)="E",U34&CHAR(160)&REPT("▢",W34)&"│ ","")&IF(LEFT(V35)="E",U35&CHAR(160)&REPT("▢",W35)&"│ ","")&IF(LEFT(V36)="E",U36&CHAR(160)&REPT("▢",W36)&"│ ","")&IF(LEFT(V37)="E",U37&CHAR(160)&REPT("▢",W37)&"│ ","")&IF(LEFT(V38)="E",U38&CHAR(160)&REPT("▢",W38)&"│ ","")&IF(LEFT(V39)="E",U39&CHAR(160)&REPT("▢",W39)&"│ ","")&IF(LEFT(V40)="E",U40&CHAR(160)&REPT("▢",W40)&"│ ","")&IF(LEFT(V41)="E",U41&CHAR(160)&REPT("▢",W41)&"│ ","")&IF(LEFT(V42)="E",U42&CHAR(160)&REPT("▢",W42)&"│ ","")
Enter the following into cell U44.
=IF(LEFT(V33)="T",U33,"")&IF(V33="T1"," ("&W33&")","")&IF(LEFT(V33)="T","; ","")&IF(LEFT(V34)="T",U34,"")&IF(V34="T1"," ("&W34&")","")&IF(LEFT(V34)="T","; ","")&IF(LEFT(V35)="T",U35,"")&IF(V35="T1"," ("&W35&")","")&IF(LEFT(V35)="T","; ","")&IF(LEFT(V36)="T",U36,"")&IF(V36="T1"," ("&W36&")","")&IF(LEFT(V36)="T","; ","")&IF(LEFT(V37)="T",U37,"")&IF(V37="T1"," ("&W37&")","")&IF(LEFT(V37)="T","; ","")&IF(LEFT(V38)="T",U38,"")&IF(V38="T1"," ("&W38&")","")&IF(LEFT(V38)="T","; ","")&IF(LEFT(V39)="T",U39,"")&IF(V39="T1"," ("&W39&")","")&IF(LEFT(V39)="T","; ","")&IF(LEFT(V40)="T",U40,"")&IF(V40="T1"," ("&W40&")","")&IF(LEFT(V40)="T","; ","")&IF(LEFT(V41)="T",U41,"")&IF(V41="T1"," ("&W41&")","")&IF(LEFT(V41)="T","; ","")&IF(LEFT(V42)="T",U42,"")&IF(V42="T1"," ("&W42&")","")&IF(LEFT(V42)="T","; ","")