Need to export table into 2 columns, one repeating, one with rest stacked
select col_a, col_b INTO foo2 from (
       select col1 as col_a, col2 as col_b from chandlerV2
       union all 
       select col1 as col_a, col3 as col_B from chandlerV2
     ) as myview;


Each part of subquery myview select main column (col1) and one of two secondary column (col2 or col3 respectively). Both part united by UNION ALL clause.

As variant you can CREATE TABLE and after that run INSERT INTO ... SELECT ...