Help with SELECT

[UBfoolin]

If I have a table:

Key A B C
=== = = =
111 A B C
222 A E C
333 B A M

Is there a way to write a query to move the data from fields A, B and C into a single column named D, grouping by the Key field?

Desired result:

Key D
=== =
111 A
111 B
111 C
222 A
222 E
222 C
and so on.

Thanks for any advice on this.

 

[ericbrunson]

select key, a from thing
union
select key, b from thing
union
select key, c from thing