The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Reload this Page Converting Pivot file to flat file
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read



Thread: Converting Pivot file to flat file
View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 10-18-2005
vskr72 vskr72 is offline
Registered User
  
 

Join Date: Aug 2005
Posts: 11
Converting Pivot file to flat file
I have a file in this format.
P1 P2 P3.........................
A001 v11 v21 v31......................
A002 v12 v22 v32............................
A003 v13 v23 v33..........................
A004 v14 v24 v34..............................
.
.
.
A00n

This has to be flattened in this format

A001 P1 v11
A001 P2 v21
A001 P3 v31
A001 P4 v41
...
...
...

Please let me know if ther is a easy way in awk to do it?

Kumar