I have a table with 8 columns
ALL,OPEN,CLOSED,RECOVERY,CLAIMS, PAYMENT1,PAYMENT2,PAYMENT3
I WOULD LIKE TO UNPIVOT THE COLUMNS INTO ROWS LIKE
ALL, PAYMENT1, PAYMENT2, PAYMENT3
OPEN
CLOSED
RECOVERY
CLAIMS
I have a table with 8 columns
ALL,OPEN,CLOSED,RECOVERY,CLAIMS, PAYMENT1,PAYMENT2,PAYMENT3
I WOULD LIKE TO UNPIVOT THE COLUMNS INTO ROWS LIKE
ALL, PAYMENT1, PAYMENT2, PAYMENT3
OPEN
CLOSED
RECOVERY
CLAIMS