Month   Col_1   Col_2   Col_3   Col_4   Col_5   
---------------------------------------------
Jan     NULL    NULL    1       1       1   

select Month, Name, value from 
TableName
    unpivot
    (
        Value 
        for Name in (Col_1,Col_2,Col_3,Col_4,Col_5)  
    ) u 

Month    Name    Value
-----------------------
Jan      Col_3   1
Jan      Col_4   1
Jan      Col_5   1

Month    Name    Value
-----------------------
Jan      Col_1   NULL
Jan      Col_2   NULL
Jan      Col_3   1
Jan      Col_4   1
Jan      Col_5   1

with cte as (select 
                  month
                  ,ifnull(col_1,-1) col_1
                  ,ifnull(col_2,-1) col_2
                  ,ifnull(col_3,-1) col_3
                  ,ifnull(col_4,-1) col_4
                  ,ifnull(col_5,-1) col_5
                   from UNPIVOT_TEST
                                  )
                                  select 
                                  month
                                  ,name
                                  ,case when value=-1 then NULL else value end as value 
                                  from cte unpivot
                                  ( 
                                  value for name in ( col_1,col_2,col_3,col_4,col_5)
                                  );

create or replace view test_data as
select *
from (VALUES ('Jan', NULL, NULL, 1, 1, 1) ) as 
               raw_data (Month, Col_1, Col_2, Col_3, Col_4, Col_5);

with 
kc_r1 as (
         -- Return a 1 row result containing only the columns that you want to unpivot on. 
         -- 2 examples below.
         select * EXCLUDE month from test_data limit 1
         -- select * ILIKE 'COL_%' from test_data limit 1 
         ),
kca as (
   select 
      -- Create an array containing the column names required in the 'unpivot'
      object_keys(object_construct_keep_null(*)) k_array
   from kc_r1
),
o as (
   select 
      month,
      object_pick(object_construct_keep_null(test_data.*), kca.k_array) k_v 
   from kca, test_data)
Select 
   month "Month",
   key "Name",
   value "Value"
from kca, o, lateral flatten (input => k_v)
;

with numbers as (
 select 1 as n union all
 select 2 as n union all
 select 3 as n union all
 select 4 as n union all
 select 5 as n
 )
select
  t.Month
, concat('col_', numbers.n) as name
, case
    when numbers.n = 1 then col_1
    when numbers.n = 2 then col_2
    when numbers.n = 3 then col_3
    when numbers.n = 4 then col_4
    when numbers.n = 5 then col_5
  end as value
from tablename t
cross join numbers