Using the following Textjoin formula but how can i adapt the result to remove/ignore "H", "W", "D", DIA", "SH", "AH" where their cells are blank?
=TEXTJOIN(" / ",TRUE,C6,L6:U6,TEXTJOIN(" ",TRUE,"H",TEXTJOIN(" ",TRUE,V6,TEXTJOIN(" ",TRUE,TEXTJOIN(" ",TRUE,"W",TEXTJOIN(" ",TRUE,W6,TEXTJOIN(" ",TRUE,"D",X6,TEXTJOIN(" ",TRUE,"DIA",Y6,TEXTJOIN(" ",TRUE,"SH",Z6,TEXTJOIN(" / ",TRUE,"AH",Z6,TEXTJOIN(" / ",TRUE,TEXTJOIN(" / ",TRUE,AB6,AC6))))))))))))
=TEXTJOIN(" / ",TRUE,C6,L6:U6,TEXTJOIN(" ",TRUE,"H",TEXTJOIN(" ",TRUE,V6,TEXTJOIN(" ",TRUE,TEXTJOIN(" ",TRUE,"W",TEXTJOIN(" ",TRUE,W6,TEXTJOIN(" ",TRUE,"D",X6,TEXTJOIN(" ",TRUE,"DIA",Y6,TEXTJOIN(" ",TRUE,"SH",Z6,TEXTJOIN(" / ",TRUE,"AH",Z6,TEXTJOIN(" / ",TRUE,TEXTJOIN(" / ",TRUE,AB6,AC6))))))))))))
MEDIA UNIT / BLACK / BAMBOO / WOOD VENEER / BLACK METAL LEGS / H 550 W 1400 D 420 DIA SH AH / CRIB 5 / LEGS |