Datastage Column Mapping logic Based on column Value (Or any SQL function to do the same)

I’m trying to find a solution in datastage (Or in SQL) – without having to use a bunch of if/else conditions – where I can map value of one column based on value of another column.

Example – Source File –

Target Output –

I can do this using Index/Match function of excel. Was wondering if datastage or Snowflake can look into all these fields similarly and automatically populate the value column to the corresponding header column!