Transforming data structure

Article View: aus.stats.s

Article #215

#215

From: 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.

Technical Details

Message-ID: <fcfd1720.0502261802.6ec37c4d@posting.google.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fa931,785b677489356c57,start
X-Google-Attributes: gidfa931,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!not-for-mail
From: chunrima@hotmail.com (jae ryu)
Newsgroups: aus.stats.s
Subject: Transforming data structure
Date: 26 Feb 2005 18:02:03 -0800
Organization: http://groups.google.com
Lines: 46
Message-ID: <fcfd1720.0502261802.6ec37c4d@posting.google.com>
NNTP-Posting-Host: 140.142.174.199
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1109469724 19197 127.0.0.1 (27 Feb 2005 02:02:04 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sun, 27 Feb 2005 02:02:04 +0000 (UTC)