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!