|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here. |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to merge rows into columns ???? | bogu0001 | Shell Programming and Scripting | 4 | 01-16-2009 07:57 PM |
| convert rows into columns | loperam | Shell Programming and Scripting | 2 | 12-01-2008 03:57 AM |
| how to convert columns to rows | suresh3566 | Shell Programming and Scripting | 6 | 11-04-2008 08:20 AM |
| How to changes rows to columns in a file | oracle123 | Shell Programming and Scripting | 4 | 07-31-2008 05:38 AM |
| Columns to rows | mgirinath | Shell Programming and Scripting | 16 | 11-29-2007 07:03 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
04-01-2009
|
||||
|
||||
|
Pivoting Dynamic rows into columns
Original file we are getting .......
Item Period Amt P1 106 1000 P1 206 1500 P1 106 2000 P2 256 5800 P2 650 7500 My output should be like this Item 106 206 256 650 ............ P1 1000 1500 0 0 ............ P1 2000 0 0 0 ........... P2 0 0 5800 7500 ............... ........... ........... ................ Hi all my requirement is quite tricky . ..its very urgent... i want to convert 1st file into as 2nd file........ i want to convert Period col values into columns and amount should be placed w.r.t Period value If corresponding amount is not available for Period then 0 should be enter for that period... and Items can be dynamically change.... means it can come P3,P4 etc....... Thanks Prakash |
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
