Forum Discussion
Same formula for multiple columns
I have a 300 columns in a file. 200 columns has a value of ratings. I need to calculate something out of it(say some formula).The same formula i need to apply to those 200 columns. Right now i see th...
You can try unpivoting your data so that each column becomes a row, with the "column type" as a column.
Name C1 C2 C3 C4 C5 C6
A A B C D E F
becomes
Name ColType Value
A 1 A
A 2 B
A 3 C
A 4 D
A 5 E
A 6 F
and you can then add a calcualted column against "Value".
Hope this helps
David