select 'a', a from t union all

select 'b', b from t union all

select 'c', c from t union all

select 'd', d from t;