The Origin Forum - Seeking help for changing Row values to Column val

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Seeking help for changing Row values to Column val

New Topic

Reply to Topic

Printer Friendly

Author

Topic

chan75

Austria
2 Posts

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.

Hideo Fujii

USA
1582 Posts

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

chan75

Austria
2 Posts

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.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000