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
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
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
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
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
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
51009
8746
8912
17986
20315
24998
5368
38934
7805
8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies
7. Shell Programming and Scripting
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
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
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
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
LEARN ABOUT DEBIAN
subject
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)