Johnson & Johnson Interview Question

Excel exercise. Pivot Vlookup. Real problem and related quest.