Jim Murphy
New Member
- Joined
- Oct 29, 2012
- Messages
- 1
I have a spreadsheet with several hundred records. I would like to populate blank fields in each record with information from another record with the same value in a particular field.
In the example below (blank cells have been replaced with ___), I want to populate all the blank fields in the column fk_unit based on the Equipment ID.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The table below shows my end goal. The underlined values are the ones I want to populate. Heres the catch.. I have a tables with several hundred records and about 160 columns. There are multiple columns I would like to populate based on the equipment ID, and the storage location for the date varies from record to record. In the example above, fk_unit was always populated for the component 'Header'. In practice, fk_unit may be populated for the component 'Tube', in which case I would like to populate the 'Header' record. Any help is much appreciated!
<colgroup><col><col><col></colgroup><tbody>
</tbody>
In the example below (blank cells have been replaced with ___), I want to populate all the blank fields in the column fk_unit based on the Equipment ID.
EquipmentID | Component Type | fk_Unit |
150082 | Header | GDU |
150082 | Tube | ___ |
150083 | Header | FCC |
150083 | Tube | ___ |
150096 | Header | TGT |
150096 | Tube | ___ |
150097 | Header | GDU |
150097 | Tube | ___ |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
The table below shows my end goal. The underlined values are the ones I want to populate. Heres the catch.. I have a tables with several hundred records and about 160 columns. There are multiple columns I would like to populate based on the equipment ID, and the storage location for the date varies from record to record. In the example above, fk_unit was always populated for the component 'Header'. In practice, fk_unit may be populated for the component 'Tube', in which case I would like to populate the 'Header' record. Any help is much appreciated!
EquipmentID | Component Type | fk_Unit |
150082 | Header | GDU |
150082 | Tube | GDU |
150083 | Header | FCC |
150083 | Tube | FCC |
150096 | Header | TGT |
150096 | Tube | TGT |
150097 | Header | GDU |
150097 | Tube | GDU |
<colgroup><col><col><col></colgroup><tbody>
</tbody>