# -*- coding: utf-8 -*-
"""
Created on Sun Dec  5 10:16:43 2021

@author: Sim
"""
import pandas as pd

wdf = pd.DataFrame([ [1, 90, 97, 98, 95], [2, 88, 92, 90, 93],
                    [3, 93, 97, 97, 94] ], 
                    columns=['trt', 'obs1', 'obs2', 'obs3','obs4'])

ldf = pd.melt(wdf, id_vars=['trt'], 
               value_vars=['obs1', 'obs2', 'obs3','obs4'],
               value_name='obs')

ldf2 = ldf.drop(columns=['variable'])

ldf3 = ldf2.sort_values(by='trt')