HI
I have data in sheet "data" and would like to unpivot them.
I click "from table" then highligh "need?" and then go to transform --> "unpivot other columns"
Excel cannot unpivot all of the selection and has error at the end of the list.
Could anyone help?
How can I add attachment?
Below is my data
<tbody>
</tbody>
I have data in sheet "data" and would like to unpivot them.
I click "from table" then highligh "need?" and then go to transform --> "unpivot other columns"
Excel cannot unpivot all of the selection and has error at the end of the list.
Could anyone help?
How can I add attachment?
Below is my data
need? | CRP GM | CRP Var | PEL GM | PEL Var | SEN GM | SEN Var | SYN GM | SYN Var |
120500 | 0.00 | 0.00 | 9,383,925.51 | 955,249.35 | (3,855,440.37) | 3,842,753.61 | 0.00 | 0.00 |
120500 | ||||||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 99,645.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 1,417,203.35 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
120500 | 0.00 | 4,985,284.50 | 0.00 | 0.00 | ||||
126500 | 0.00 | 0.00 | 6,433,038.40 | 0.00 | 0.00 | 1,089,998.78 | 0.00 | 0.00 |
126501 | 81,775.22 | 0.00 | 3,873,587.93 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
128000 | 0.39 | 0.00 | (6,418,731.68) | 6,726,902.79 | (5,396,179.28) | 5,966,686.33 | ||
128000 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
128000 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
128000 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
128000 | 0.00 | 0.00 | 0.00 | 0.00 | (8,666,646.95) | 0.00 | 0.00 | 0.00 |
128000 | 0.00 | 0.00 | (5,262,900.02) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
128000 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
128000 | (80,903.59) | 0.00 | (31,846,019.61) | (10,918,044.77) | (21,505,510.70) | 44,388.10 | #DIV/0! | #DIV/0! |
145200 | 0.00 | (50,000.00) | 11,875.62 | (0.00) | 0.00 | 0.00 | 0.00 | 0.00 |
145200 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | |||
145200 | 0.00 | (44,341.08) | (44,341.08) | 0.00 | 0.00 | |||
201100 | 2,406.21 | 561.76 | (10.87) | 0.00 | 378,520.49 | (4,221,274.12) | 0.00 | 0.00 |
201100 | ||||||||
201100 | 0.00 | (282,360.10) | 0.00 | 0.00 | ||||
201100 | 0.00 | (16,931.82) | 0.00 | 0.00 | ||||
201100 | 0.00 | 0.00 | (302,369.52) | 0.00 | ||||
201100 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
201100 | 0.00 | 0.00 | (2,597,629.83) | 0.00 | ||||
201100 | (80,903.59) | (38,509.18) | 0.00 | 0.00 | ||||
201100 | 0.00 | 0.00 | (18,833.50) | 0.00 | ||||
201100 | 0.00 | 0.00 | (5,269,998.44) | 0.00 | ||||
201100 | 0.00 | 0.00 | (187,114.26) | 0.00 | ||||
201100 | 0.00 | (5,276,925.00) | 0.00 | 0.00 | ||||
201100 | 0.00 | (2,226,750.00) | 0.00 | 0.00 | ||||
201100 | 0.00 | (3,312,917.30) | 0.00 | 0.00 | ||||
201100 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
201101 | 0.01 | 0.00 | 0.00 | 0.00 | (138,430.01) | 0.00 | 0.00 | 0.00 |
201101 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
201101 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
201101 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
201101 | 0.00 | 0.00 | (3,503,996.93) | (369,591.00) | ||||
201101 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
201101 | 0.00 | 0.00 | 0.00 | 0.00 | ||||
202200 | (80,903.59) | (0.00) | (11,154,393.41) | (0.00) | (8,494,499.28) | (0.00) | 0.00 | 0.00 |
202201 | 0.00 | 0.00 | 0.00 | 0.00 | (3,503,996.93) | (0.00) | (369,591.00) | 0.00 |
242100 | 0.00 | 0.00 | (1,707,891.25) | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
242100 | 0.00 | 574,195.77 | 574,195.77 | 0.00 | 0.00 | |||
242100 | 0.00 | 0.00 | 0.00 | 0.00 |
<tbody>
</tbody>
Last edited: