I'm sure this has been asked before - if so please direct me.
I have Fields: LastName,FirstName,Spouse,Position,Spouse Position
It's a list that also includes people that are singles.
Just looking for direction how to keep my original list AND elsewhere to have a list that derives and splits each person and their position into their own row (ie. bringing in the LastName for the wife). I am open to VBA ideas. I am hoping that the original list can be updated which will automatically update this new list as well.
Take this
<tbody>
</tbody>
To get this - that can continually update from the is list above.
<tbody>
</tbody>
I have Fields: LastName,FirstName,Spouse,Position,Spouse Position
It's a list that also includes people that are singles.
Just looking for direction how to keep my original list AND elsewhere to have a list that derives and splits each person and their position into their own row (ie. bringing in the LastName for the wife). I am open to VBA ideas. I am hoping that the original list can be updated which will automatically update this new list as well.
Take this
LastName | FirstName | Spouse | Position | Spouse Position |
FlintStone | Fred | Wilma | Quarry Operator | Home Manager |
FlintStone | Bambam | |||
Lightyear | Buzz | Star Commander | ||
Mouse | Mickey | Minnie | Disney Ambassador | Bow Distributor |
<tbody>
</tbody>
To get this - that can continually update from the is list above.
LastName | FirstName | Position |
FlintStone | Fred | Quarry Operator |
FlintStone | Wilma | Home Manager |
FlintStone | Bambam | |
Lightyear | Buzz | Star Commander |
Mouse | Mickey | Disney Ambassador |
Mouse | Minnie | Bow Distributor |
<tbody>
</tbody>