Convert vertical table to horizontal in oracle

I have the following table format.

I need to convert this table to follow.

Anyone have an idea how to do this?

>Solution :

You may use pivoting logic:

SELECT
    POLNO,
    MAX(CASE WHEN NAME = 'PRMA' THEN PRM END) AS PRMA,
    MAX(CASE WHEN NAME = 'PRMB' THEN PRM END) AS PRMB,
    MAX(CASE WHEN NAME = 'PRMC' THEN PRM END) AS PRMC,
    MAX(CASE WHEN NAME = 'PRMD' THEN PRM END) AS PRMD
FROM yourTable
GROUP BY POLNO;