Hi,
I have a table like this:-
name a b c d
john 0 0 5 0
dave 2 4 0 5
mark 0 9 0 8
i would like one line for each name where the value isn't zero i.e.
name item value
john c 5
dave a 2
dave b 4
dave d 5
mark b 9
mark d 8
could anyone please point me in the right direction?
thanks a lot.
mark.
I have a table like this:-
name a b c d
john 0 0 5 0
dave 2 4 0 5
mark 0 9 0 8
i would like one line for each name where the value isn't zero i.e.
name item value
john c 5
dave a 2
dave b 4
dave d 5
mark b 9
mark d 8
could anyone please point me in the right direction?
thanks a lot.
mark.