Transforming data structure

Thread View: aus.stats.s

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by jae ryu Sun, 27 Feb 2005 02:02

#215

Author: jae ryu
Date: Sun, 27 Feb 2005 02:02

46 lines
1360 bytes

Dear Users.
Since I am just a beginner, I desperately need your kind help.
I don't know where I got stuck.
I want to change my current data into the desired one as below.  
please, help me out to solve this problem. 

My current datasets look like this: 

Data 1 for year 1990
A	30	
B	25	
C	10	

Data 2 for year 1991
A	10
B	20
C	10

Data 3 for year 1992
A	20
B	5
C	7

Data 4 for year 1993
A	7
B	8
C	6


And, the result should look like.

A	1990	30
A	1991	10
A	1992	20
A	1993	7
B	1990	25
B	1991	20
B	1992	5
B	1993	8
C	1990	10
C	1991	10
C	1992	7
C	1993	6


Thanks you for your help.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads