VBA Stock List creation

Hello All,

I am new here and as usual someone with a coding problem.
New to excel vba but have had many years of access vba coding.

I have a sheet with a range of products (6 chr Uppercase text) and quantities, each represents
one pallet of stock in a row in warehouse.
I need to create a stock take list of the row name (first row of sheet) then each individual (unique)
product and count in that row. Some rows can have multiple different products.
Have been looking at the Scripting Dictionary as it returns the fastest results, so far unsuccessfully.

Any assistance would be greatly appreciated.

Mike