How to convert the below data to the desired output:
DAY | NET_SALES | COST_OF_SALES | GROSS_PROFIT |
---|---|---|---|
12 | 500 | 400 | 100 |
11 | 600 | 500 | 100 |
19 | 1791 | 1500 | 291 |
16 | 6300 | 5350 | 950 |
desired output:
DAY | 12 | 11 | 19 | 16 |
---|---|---|---|---|
NET_SALES | 500 | 600 | 1791 | 6300 |
COST_OF_SALES | 400 | 500 | 1500 | 5350 |
GROSS_PROFIT | 100 | 100 | 291 | 950 |