Stock report branchwise , need to view my way

[makinmomb]

Find attached ,

Sheet 2 is report pull from the operating software of the company

I need to see the report my way that is sheet1

[bolulusam]

see this spreadsheet

[makinmomb]

Yes that is it , please can you edit me that N/A to read numeric 0

I must say I will be able to shock team of sales as to what they have
not stocked , product range is very

Thank you very much

[makinmomb]

Will be very handy indeed since product range is very wide plus will be able to use
it for more than one purpose

[makinmomb]

There is one small trouble though , if the codes were to pick automatically , it would be cooler

[makinmomb]

A formula on a2 that will pick the unique record of that code ?