Hi, I have a table in the following format:
| account number | FC_Product1 | FC_Product2 | FC_Product3 | FC_Total | LC_Product1 | LC_Product1 | LC_Product1 | LC_Total | Total |
|---|---|---|---|---|---|---|---|---|---|
| 1 | sum(FC_Producr_1,FC_Product_2, FC_Product3) | sum(LC_Producr_1,LC_Product_2, LC_Product3) | sum(FC_Total, LC_Total) | ||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| Total |
and need to change format to this one:
| account number | Product_1 | Product_2 | Product_3 | Total | |
|---|---|---|---|---|---|
| 1 | FC | ||||
| 2 | FC | ||||
| 3 | FC | ||||
| 4 | FC | ||||
| 5 | FC | ||||
| 1 | LC | ||||
| 2 | LC | ||||
| 3 | LC | ||||
| 4 | LC | ||||
| 5 | LC | ||||
| Total |
Can anyone show me how I can do it? Many thanks in advance!