Forum Discussion
rswami_4
Helper I
Helper ITable transformation
I am looking for help to transpose/transform a table so that I could create a useful waterfall chart out of the output. For example: The source table looks like this: Wave Cat1 Cat2 Cat3 ...
rswami_4Helper I
Helper IOr the transformation could be done into the following table which will have the same effect:
| Product | Category | Value |
| Product 1 | Cat 1 | $11.60 |
| Product 1 | Cat 2 | $91.51 |
| Product 1 | Cat 3 | $86.41 |
| Product 1 | Cat 4 | $18.27 |
| Product 2 | Cat 1 | $32.71 |
| Product 2 | Cat 2 | $29.30 |
| Product 2 | Cat 3 | $96.82 |
| Product 2 | Cat 4 | $84.40 |
| Product 3 | Cat 1 | $83.06 |
| Product 3 | Cat 2 | $14.36 |
| Product 3 | Cat 3 | $68.78 |
| Product 3 | Cat 4 | $83.72 |
| Product 4 | Cat 1 | $77.71 |
| Product 4 | Cat 2 | $15.72 |
| Product 4 | Cat 3 | $94.48 |
| Product 4 | Cat 4 | $40.85 |
| Product 5 | Cat 1 | $94.78 |
| Product 5 | Cat 2 | $36.84 |
| Product 5 | Cat 3 | $68.96 |
| Product 5 | Cat 4 | $12.38 |
| Product 6 | Cat 1 | $0.92 |
| Product 6 | Cat 2 | $42.69 |
| Product 6 | Cat 3 | $81.30 |
| Product 6 | Cat 4 | $23.58 |
| Product 7 | Cat 1 | $8.39 |
| Product 7 | Cat 2 | $30.20 |
| Product 7 | Cat 3 | $70.32 |
| Product 7 | Cat 4 | $96.37 |
| Product 8 | Cat 1 | $18.51 |
| Product 8 | Cat 2 | $88.55 |
| Product 8 | Cat 3 | $49.71 |
| Product 8 | Cat 4 | $72.65 |
| Product 9 | Cat 1 | $71.56 |
| Product 9 | Cat 2 | $58.05 |
| Product 9 | Cat 3 | $53.13 |
| Product 9 | Cat 4 | $27.28 |
