Sponsored Content
Full Discussion: Horizontal to vertical
Top Forums UNIX for Dummies Questions & Answers Horizontal to vertical Post 302553961 by Xterra on Friday 9th of September 2011 09:58:02 AM
Old 09-09-2011
Horizontal to vertical

Hi,
Silly question, if I have an excel file that looks something like this:

 
................. Subject 1 Subject 2 Subject 3 Subject 4
Fever..............13...........9.............23..........14
Headache.........2............12...........18..........23
Bleeding...........21...........45...........56.........88
Trauma............11...........23...........78.........22

But I need the information in columns rather than row:

 
................. Fever Headache Bleeding Trauma
Subject 1.......13.........2...........21........11
Subject 2........9.........12..........45........23
Subject 3.......23.........18.........56.........78
Subject 4.......14.........23.........88.........22


I know is a silly question but I need an AWK or perl script. I just do not know how to accomplish it.
Any help will be very much appreciated!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Vertical an horizontal pivoing in unix

Please help me to do Vertical an horizontal pivoing in unix in single run. The input file is like this- MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4 M1|P1|PR1|F11|F12|F13|F14 M1|P1|PR2|F21|F22|F23|F24 M1|P1|PR3|F31|F32|F33|F34 M2|P2|PR1|F41|F42|F43|F44 M2|P2|PR2|F51|F53|F54|F55... (4 Replies)
Discussion started by: marut_ashu
4 Replies

2. Shell Programming and Scripting

combine files in horizontal way, not vertical.

Hi Everyone, I have three files. FileA: aaaa aaaa bb ccc FileB: 21 2 FileC: eeeeeee e eee ee Would like to combine three of them, not like cat, to cat three files, but the output should be like: (3 Replies)
Discussion started by: jimmy_y
3 Replies

3. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

4. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

5. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

6. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

7. Shell Programming and Scripting

Help! output format from vertical to horizontal

Hi All, please help to achieve the desired output Example: I have a file which contains the below data empname robert empid 787 design consultant empname alex empid 898 design advocate Desired output should be empname empid design robert 787 consultant (19 Replies)
Discussion started by: rocky2013
19 Replies

8. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

9. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

10. Shell Programming and Scripting

Transform vertical into horizontal list

Hi, I am creating a script that will pull data from database. The only thing missing now is that i have to transform the lines into horizontal list. EXAMPLE 2015-07-15 09:00:00.0 |TCSERVER01 |5354 2015-07-15 09:01:00.0 |TCSERVER01 |6899 ... (5 Replies)
Discussion started by: reignangel2003
5 Replies
Subject(3I)						    InterViews Reference Manual 					       Subject(3I)

NAME
Subject - object with views SYNOPSIS
#include <InterViews/subject.h> DESCRIPTION
A subject is an object that has one or more views that it wishes to notify when it changes. The SubjectIteractor class can be used if it is necessary to iterate through the views of a subject explicitly. Because subjects are shared, Subject is a subclass of Resource. To allow for the possibility of multiple inheritance, in which case only a single copy of resource information should be maintained, Resource is a virtual base class. PUBLIC OPERATIONS
enum UpdateHint { attaching, detaching, setting, changing } This type enumerates possible hints when a subject is notifying a view that it has changed. The attaching hint indicates that a view has attached to the subject. The detaching hint means that the subject is being deleted and the view should consider itself detached. The setting hint means that the subject's value has been set, though possibly to the same value as it already has. The changing hint means that the value is set to something different than it was previously. virtual void attach(View*) Add a view to the subject's list. virtual void detach(View*) Remove a view from the subject's list. virtual void notify(UpdateHint = changing) Notify all the views of a subject that it has been updated. virtual boolean viewed_by(View*) Return whether a given view is on the subject's list of views. virtual void Attach(Interactor*) This function is equivalent to attach and is provided solely for backward compatibility. It will be removed in a future version. virtual void Detach(Interactor*) This function is equivalent to detach and is provided solely for backward compatibility. It will be removed in a future version. virtual void Notify() This function is equivalent to notify(changing) and is provided solely for backward compatibility. It will be removed in a future version. boolean IsView(Interactor*) This function is equivalent to viewed_by and is provided solely for backward compatibility. It will be removed in a future version. SUBJECTITERATOR OPERATIONS
A subject iterator can be used to iterate through the views in a subject. SubjectIterator(Subject*) Create a subject iterator for the given subject. The iterator is only valid as long as the subject exists. virtual void init() Reset the iteration to start at the beginning of the list. This operation is called by the constructor. virtual boolean more() Return whether there are more views in the list. virtual View* cur() Return the current view. virtual void remove() Remove the current view from the list. virtual void next() Move the iteration to the next view in the list. SEE ALSO
View(3I) InterViews 29 June 1989 Subject(3I)
All times are GMT -4. The time now is 06:52 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy