I think this is an easy one I am overlooking. I thought I could use either of the formulas in the title, but no go. Open to any other ideas.
Header Column A is the Part Number,
Header column B is the Category Spec, (I want to keep this as a header and shift column C under it)
Header column C is the spec criteria that I want listed under column B (B2,B3, and so on).
What is the most efficient formula to shift column C from there to B, etc?