Convert Column data values to rows

Shell Programming and Scripting
1

Hi all ,

I have a file with the below content

Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Oct|Nov|Dec|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep
 
Data section 
8243651u7|juanalk||emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|10|20|30|40|50|0|0|0|0|0|0|0

I need to convert this file as below

Header Section 
employee |employee name |Period|Job description |Job code |Unit code |Account |geography |C1 |C2 |C3|C4|C5|C6|C7|C8|C9|Csource |Data
 
 
Data section 
8243651u7|juanalk|Oct|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|10
8243651u7|juanalk|Nov|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|20
8243651u7|juanalk|Dec|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|30
8243651u7|juanalk|Jan|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|40
8243651u7|juanalk|Feb|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|50
8243651u7|juanalk|Mar|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Apr|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|May|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Jun|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Jul|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Aug|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0
8243651u7|juanalk|Sep|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||source1|0

Basically all the 12 months data is coming in columns initially and I need to keep that data into rows now .

Can anyone help me how this can be done in unix fastly

thanks

2

Any attempts from your side?

---------- Post updated at 11:19 ---------- Previous update was at 11:02 ----------

However, try

awk     '/[Ss]ection/   {print; next}
         NR==2          {for (i=NF; i>=NF-11; i--) {M=$i; $i=""}; sub ("\|*$", "|Data")
                        }
         NR>4           {FN=NF  
                         for (i=FN; i>=FN-11; i--)      {D=$i; $i=""}; sub ("\|*$", "")
                         for (i=FN-11; i<=FN; i++)      {$3=M; $(FN-11)= D  
                                                         print
                                                        }
                         next
                        }
         1
        ' FS="|" OFS="|" file
Header Section
employee|employee name||Job description|Job code|Unitcode|Account|geography|C1|C2|C3|C4|C5|C6|C7|C8|C9|Csource|Data
 
Data section 
8243651u7|juanalk|Oct|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|10
8243651u7|juanalk|Nov|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|20
8243651u7|juanalk|Dec|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|30
8243651u7|juanalk|Jan|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|40
8243651u7|juanalk|Feb|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|50
8243651u7|juanalk|Mar|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Apr|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|May|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Jun|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Jul|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Aug|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0
8243651u7|juanalk|Sep|emplsi|1235|7835|67239|Geo12|hrfnu|epoifd|jdu|kifdm|isj|||||sopurce1|0