sorting horizontally

[Anonymous]

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!

[Anonymous]

yup I agree...taking 2 combinations is a flawed approach!