Like UNPIVOT in SQL!
You can just do it with a UNION ALL (you may or may not need the ORDER BY part, depending on your use-case):

SELECT
    a, b as `E`
FROM
    a
UNION ALL 
SELECT
    a, c as `E`
FROM
    a 
ORDER BY
    a ;


You can check it here.