display values from vertical line to horizontal line

Check this:

SELECT customer_id, collector, mc_code, customer_name, industry, isegment, segment
FROM yourTableName
UNPIVOT (
    segment FOR segmentname IN (segment2, segment3, segment4, segment5, segment6, segment7, segment8)
) AS unpivoted_data;