Scan thru an array and create a new column with value if there is one other than #NA

Dear Excel gurus

I have created a sheet which consists of Container number and series of item and counts which are the results of the vlookup from 3 different sheets. Now I would like to scan this matrix and create a another sheet with container no. and one item and count column which will have the actual values other than #NA.

How can I create this sheet? What formula/function should I use to create it?

Thanks