I want to transpose the dataset below based on the Doc. # column which is a key number for each respective field name and reformat to be horizontal with respective New/Old value columns.The original data

I have tried both df.transpose() to reformat the dataframe and df.groupby() methods and can’t get the ideal output below.Desired output