Danmero,
Thanks for the reply.
Am using your Awk script, but its failing giving me the below error.
Awk script used
awk 'BEGIN{FS=OFS="|";print "ID","Col_Name","Value"}!(NR-1){split($0,l,FS);next} {for(o=1;++o<NF
{split($o,_,",");for(O=0;O++<length(_)
{print $1,l[o],_[O]}}}' denorm_sample.txt
Comments
Here denorm_sample.txt is the file containing the data from above original post,
and am running this in command mode.
Output
ID|Col_Name|Value
awk: cmd. line:1: (FILENAME=denorm_sample.txt FNR=2) fatal: attempt to use array `_' in a scalar context