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.
thank you for your fast response I already saw your demo. but I didn't make any mistakes in my example table. in another hand when I saw your demo the first and second row is correct but the rest does not match my example. table green is the result I wanted from the source data table blue. by the way, thank you again for trying to help.
*I want to try to explain further but I really bad at English
*I want to try to explain further but I really bad at English
Can you explain why the lower left cell in the second table should be 6 while the lower left cell in the first table contains C?
- 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.OK, I see what you want now. New version attached.
- oh that's awesome.. thank you so much