If I have a table like the below
Booking ref cage box pallet carton
GE12344as 0 1 2 0
KD1231241 1 0 1 7
How can I create and SQL select statement that can return field columns into rows to produce something like...
Booking ref type qty
GE12344as box 1
GE12344as pallet 2
KD1231241 cage 1
KD1231241 pallet 1
KD1231241 carton 7