| Home |
| Search |
| Today's Posts |
|
#1
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
| Export Pivot Table Data to Excel Table | Excel Discussion (Misc queries) | |||
| convert Pivot table back to Data table | Excel Discussion (Misc queries) | |||
| Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
Linear Mode
