Modyfy table data

  • Thread starter Thread starter matti.koski
  • Start date Start date
M

matti.koski

Please advise how to change the format of table 1 to table 2:

Table 1
Family Code Person_ID Family member
2727 6453 Mother
2727 19133 Daughter
2727 5084 Brother
2727 5254 Father
2727 5261 Daughter
2467 17708 Brother
2467 5029 Mother
2467 6855 Daughter
2467 17703 Father
2736 5835 Brother
2736 7245 Daughter
2736 5629 Mother
2736 5677 Brother
2736 5813 Father
2807 19568 Brother
2807 19569 Daughter
2807 19570 Daughter
2807 19561 Daughter
2807 19562 Father
2807 19565 Mother
2907 20135 Daughter
2907 5076 Mother
2907 6042 Father
2907 7368 Daughter


Table 2
Family Code Person_ID Family member Person_ID Family member Person_ID Family
member Person_ID Family member Person_ID Family member
2727 6453 Mother 19113 Daughter 5084 Brother 5254 Father 5261 Daughter
2467 17708 Brother 5029 Mother 6855 Daughter 17703 Father
.. . . . . . . . . . .
.. . . . . . . . . . .
 
Back
Top