In excel multiple formulas to apply for same Column

Hi All,

Hope all are being safe!

i have below question?
i applied formulas for below image and got unique account number that is 123456 written in multiple columns


but i want this formulas output to be in one column
i have used if condition but not abt to insert formula in particular column like below

can any one help me please

Thanks a lot in Advance