import pandas as pd

data = {"Box": ["Box1", "Box1", "Box1", "Box2", "Box2", "Box2"],
        "Dimension": [ "Length", "Width", "Height", "Length", "Width", "Height"], 
        'Value': [6, 4, 2, 5, 3, 4]}
messy = pd.DataFrame(data, columns = ["Box","Dimension", "Value"])
tidy = messy.pivot(index = "Box" ,columns = "Dimension", values = "Value").reset_index()

V = tidy["Length"] * tidy["Width"] * tidy["Height"]
tidy["Volume"] = V

swap= list(tidy)
swap[1], swap[2]= swap[2], swap[1]
swap[2],swap[3] = swap[3], swap[2]
tidy = tidy.reindex(columns = swap)
print(tidy)