Sample Header Ad - 728x90

Transform .csv into 3 columns and a row

3 votes
2 answers
368 views
Sample Input:
id,Product1,Product2,Product3,Product4
1,0.1,0.3,0.8,0.7
2,0.6,0.7,0.5,0.9
I need output as :
id,productname,product_val
1,Product1,0.1
1,Product2,0.3
1,Product3,0.8
1,Product4,0.7
2,Product1,0.6
2.Product2,0.7
3,Product3,0.5
I had tried
awk -F, 'NR==1 { for (i=1; i1 { for (i=1; i
Asked by Hardik (33 rep)
Mar 17, 2015, 07:12 AM
Last activity: Mar 2, 2025, 10:51 AM