| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Create new records from existing ones based on 'rule'?
I am trying to pull apart records I uploaded that are set up something like
this; MainField | Other Fields | AssociatedFIeld1 | AssociatedFieldN There can be anywhere from zero to 6 Associated Fields. Trying to break a new record apart for each e.g. MainRecordX | Other Fields | WidgetA | WidgetB MainRecordY | Other FIelds |WidgetC | Widget D | WidgetE MainRecordZ | Other FIelds should become MainRecordX | Other Fields | WidgetA MainRecordX | Other Fields | WidgetB MainRecordY | Other Fields | WidgetC MainRecordY | Other Fields | WidgetD MainRecordY | Other Fields | WidgetE MainRecordZ | Other Fields Any insights appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a rule | Excel Worksheet Functions | |||
| how do i use sturge's rule to create frequency table? | Excel Discussion (Misc queries) | |||
| How to add text to all existing records in one column? | Excel Discussion (Misc queries) | |||
| Dynamically create worksheets in Excel based off existing data? | Excel Discussion (Misc queries) | |||
| Insert without disturbing existing records | Excel Discussion (Misc queries) | |||
Threaded Mode
