daigia_dzadzich
New Member
- Joined
- Jan 5, 2016
- Messages
- 3
Hi,
I'm currently using excel 2010 & possibly upgrade to a later version in a near future. My question is that I currently have a large excel sheet with data look like below (Please note that the common fields are the member id & dependent associate id):
<tbody>
</tbody>
What formula & syntax to move the data which have the end result looking like this:
<tbody>
</tbody>
Could you please help? Appreciate any inputs/assistants.
Thank you in advance,
Chris
I'm currently using excel 2010 & possibly upgrade to a later version in a near future. My question is that I currently have a large excel sheet with data look like below (Please note that the common fields are the member id & dependent associate id):
member Id | name | dependent associate id | dependent name |
1 | Jim | 1 | Carol |
2 | Todd | 2 | Sue |
2 | Sam | ||
3 | Chris | 3 | Kristy |
3 | Aiden | ||
3 | Isabella |
<tbody>
</tbody>
What formula & syntax to move the data which have the end result looking like this:
member id | name | dependent name 1 | dependent name 2 | dependent name 3 |
1 | Jim | Carol | N/A | N/A |
2 | Todd | Sue | Sam | N/A |
3 | Chris | Kristy | Aiden | Isabella |
<tbody>
</tbody>
Could you please help? Appreciate any inputs/assistants.
Thank you in advance,
Chris