Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have data in a table as shown below. I want to show maximum value out of L, W, and H as L. Is there any way I can sort the values in the row? Currently I am creating a single column, sort values there, and then reverse cross table.
Item | L | W | H |
A | 2 | 4 | 6 |
B | 5 | 8 | 3 |
C | 7 | 2 | 4 |
D | 11 | 14 | 6 |
E | 8 | 6 | 23 |
result table:
Item | L | W | H |
A | 6 | 4 | 2 |
B | 8 | 5 | 3 |
C | 7 | 4 | 2 |
D | 14 | 11 | 6 |
E | 23 | 8 | 6 |
Any help is much appreciated!
yup I agree...taking 2 combinations is a flawed approach!