create table pricelists (id_goods int, pricelist1 money, pricelist2 money, pricelist3 money )

create table new_pricelists (id_goods int, pricelist int, price money )

create table tmps (goods int, pricelist1 money, pricelist2 money, pricelist3 money)
insert tmps values (1, 10, 20, 30)
insert tmps values (2, 120, 220, 320)
insert tmps values (3, 130, 230, 330)
select * from tmps 

select goods, pricelist, price from tmps  UNPIVOT (price for pricelist in (pricelist1 , pricelist2 , pricelist3)) up
drop table tmps 

create table tmps (goods int, pricelist1 money, pricelist2 money, pricelist3 money)
insert tmps values (1, 10, 20, 30)
insert tmps values (2, 120, 220, 320)
insert tmps values (3, 130, 230, 330)
--select * from tmps 

select goods, pricelist, price from tmps  UNPIVOT (price for pricelist in (pricelist1 , pricelist2 , pricelist3)) up
--drop table tmps

;
with A as (
  select * from (values('pricelist1'),('pricelist2'),('pricelist3')) as T (pricelist)
)
, B as (
  select * from tmps cross join A
)
select goods, pricelist
      ,case pricelist 
         when 'pricelist1' then pricelist1
         when 'pricelist2' then pricelist2
         when 'pricelist3' then pricelist3
       end
 from B;

drop table tmps;

select t.goods, x.pricelist, x.price 
from tmps t
cross apply(
  select 'pricelist1',t.pricelist1 union all 
  select 'pricelist2',t.pricelist2 union all
  select 'pricelist3',t.pricelist3
) x (pricelist, price)

select goods,'pricelist1',pricelist1 from tmps union all 
select goods,'pricelist2',pricelist2 from tmps union all
select goods,'pricelist3',pricelist3 from tmps

 select price, 1, goods, (case when pricelist = 'pricelist1' then (select COL1 from #T_PriceHeads) 
								when pricelist = 'pricelist2' then (select COL2 from #T_PriceHeads) 
								else		(select COL3 from #T_PriceHeads)	end) t 
				from tmps
				UNPIVOT (price for pricelist in (pricelist1, pricelist2, pricelist3)) up
				where price > 0

(case when pricelist = 'pricelist1' then (select COL1 from #T_PriceHeads) 
								when pricelist = 'pricelist2' then (select COL2 from #T_PriceHeads) 
								else		(select COL3 from #T_PriceHeads)	end) t