Forum Discussion
Solved
Transform data
Hello everyone Can anyone help me transform data from table one (blue) to table 2 (green). is there any formula I can use so I don't have to insert data manually? Thank you in advance for you...
OK, I see what you want now. New version attached.
because in table blue Res5 put A in 6 (1-6:ranking). that's why the lower left cell in the second table should be 6.
like in table blue Res5 put C in column 1 (means ranking1) so in table green Res5 column C should be 1.
like in table blue Res5 put C in column 1 (means ranking1) so in table green Res5 column C should be 1.
OK, I see what you want now. New version attached.
- oh that's awesome.. thank you so much