Help to control pandas.melt function

[vanphuht91]

I’m using pandas to processing my raw data.
I have raw data like this:
   

I want to convert some columns to row using pd.melt like this:
   

But, I don’t know how to move USL & LSL transpose to 2 columns.
Can anyone help me.
Thanks so much!!!
My file:

https://docs.google.com/spreadsheets/d/1...ue&sd=true

Larz60+ write Jun-17-2023, 02:34 PM:
Please post all code, output and errors (it it's entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to make sure the code is presented as you expect before hitting the "Post Reply/Thread" button.
Noone likes to open links.