The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Seeking help for changing Row values to Column val

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
chan75 Posted - 01/05/2016 : 4:44:09 PM
Hi,
I will be greatful if someone can help me with the following:

I get experimental data in an ASCII file which looks like:

X Y
1 0.54
1 0.59
1 0.62
2 1.44
2 1.35
2 1.30
3 1.94
3 2.01
3 2.11

As you can see that there are different Y values for a single X. I want all Y values of a particular X in different columns, like below:

X Y1 Y2 Y3
1 0.54 0.59 0.62
2 1.44 1.35 1.30
3 1.94 2.01 2.11

There are hundreds of rows and without 'code', its an impossible task. Will appreciate your help. Many thanks.

chan.
2   L A T E S T    R E P L I E S    (Newest First)
chan75 Posted - 01/05/2016 : 5:42:44 PM
Dear Hideo Fujii,

That was a super fast reply. A BIG THANKS to you. You made my day. It works.

Have a nice day,

best regards,
chan.
Hideo Fujii Posted - 01/05/2016 : 5:08:43 PM
Hi chan,
Could you please try the following steps to see if it works for your data?
1) Unstack worksheet ("Worksheet: Unstack Columns") set the X column as the Group Column, 
   and Y column as Data to be Unstacked.
2) Transpose the unstacked worksheet ("Worksheet: Transpose") set the Label Type to Comments, 
   and Output Worksheet to New Sheet.
Hope this works.

--Hideo Fujii
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000