create an excel sheet that format my input content to new pattern

I have an .xls sheet that export my inventory itens, I need to create a new excel sheet with formulas to remove unnecessary lines and columns and organize in a new column data.

Examples input and output in chat.