merge many characters(letters , numbers, symbols)from three columns to one

[abdelfattah]

hello
what I want is very complicated what I want as picture when i write in column b,c,d automatically merge in column a so the first should write BS after this letters sometimes I OR J OR T theses depend on column d the first letter after this should bring what contain in column c after this bring just the numbers or numbers with symbols without any letter

CODE	tire	type	origin
BSTB251757013	175/70R13	B25	THI
BSJ613V19514	195R14C	613V	JAP
BSJVSDL26525**	26.5R25**	VSDL	JAP
BSIVMTP180033**	1800R33**	VMTP	INDO

 

[abdelfattah]

thank you so much , you did a great work for me