How to get different column names into one column and corresponding values into one column

User_QDHXF

Currently, I have a table like:

I need to change it like:

Please let me know what might be the best approach.

Thank You

Jan Gorkow

Hi @User_QDHXF ,

this is best done with unpivot:

SELECT id, category, NVL (VALUE, 0) AS VALUE
 FROM tbl
    UNPIVOT INCLUDE NULLS (VALUE
               FOR category
               IN (category1 AS 'Category 1',
                category2 AS 'Category 2',
                category3 AS 'Category 3'))

Best regards,

Jan

Jan Gorkow

Hi @User_QDHXF ,

this is best done with unpivot:

SELECT id, category, NVL (VALUE, 0) AS VALUE
 FROM tbl
    UNPIVOT INCLUDE NULLS (VALUE
               FOR category
               IN (category1 AS 'Category 1',
                category2 AS 'Category 2',
                category3 AS 'Category 3'))

Best regards,

Jan

User_QDHXF

Thank you @Jan Gorkow