
vinodkaushik
Novice
Jul 28, 2009, 12:43 AM
Post #1 of 3
(3974 views)
|
Mapping values with Column header and row header
|
Can't Post
|
|
Hi, I have some files with below data. sample File 1: sitename1,2009-07-19,"A1",11975,17.23 sitename1,2009-07-19,"A2",11,0.02 sitename1,2009-07-20,"A1",2000,17.23 sitename1,2009-07-20,"A2",538,0.02 I want to map the values in column 4 with column 2 and 3 as shown below. Output required. *Site,Type,2009-07-19,2009-07-20* sitename1,"A1",11975,2000 sitename1,"A2",11,538 I will really appreciate any quick help. Regards, VKS
|