|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 12th, 2010, 11:20 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modyfy table data
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 .. . . . . . . . . . . .. . . . . . . . . . . -- Matti 
|
|
#2
February 12th, 2010, 01:50 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modyfy table data
Create a PivotTable? Very helpful at grouping similar information.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* " wrote: 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 . . . . . . . . . . . . . . . . . . . . . . -- Matti
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
