Hi,
I am trying to develop a spreadsheet with a supply chain focus. I have approx 16K rows and 14 categories. Basically, each cell has an A, B. C. D. E, F etc (Column A). I want A = Pencils, B = Pens, C = Paper in the cell next to it in the adjacent column, B to show the name (Pen, Pencil...