wakerider017
Board Regular
- Joined
- Jun 10, 2015
- Messages
- 77
Hey guys, I have two data sets that I want to combine. Data is currently on two different worksheets.
Below is an example of what I am trying to do, but my actual data has more columns for both Opportunity and Contacts. I also have many more rows.
<colgroup><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>
<colgroup><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>
I need to link them by the Account number.
Ideally I'd like a hierarchy, where each Opportunity has its own row and lists all the related contacts underneath. Not sure how to do that? Can this be done in a pivot table
Thinking output would be something like this:
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>
Below is an example of what I am trying to do, but my actual data has more columns for both Opportunity and Contacts. I also have many more rows.
Opportunity | Account | Stage |
1 | 1 | Open |
2 | 2 | Closed |
3 | 3 | Open |
4 | 1 | Open |
5 | 2 | Closed |
<colgroup><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>
Contact | Account | Name |
1 | 3 | Bob |
2 | 2 | John |
3 | 1 | Mary |
4 | 3 | Tina |
5 | 1 | Tim |
<colgroup><col style="text-align: center;"><col span="2" style="text-align: center;"></colgroup><tbody>
</tbody>
I need to link them by the Account number.
Ideally I'd like a hierarchy, where each Opportunity has its own row and lists all the related contacts underneath. Not sure how to do that? Can this be done in a pivot table
Thinking output would be something like this:
Opportunity | Account | Stage |
1 | 1 | Open |
Contact | Account | Name |
3 | 1 | Mary |
5 | 1 | Tim |
Opportunity | Account | Stage |
2 | 2 | Closed |
Contact | Account | Name |
2 | 2 | John |
Opportunity | Account | Stage |
3 | 3 | Open |
Contact | Account | Name |
1 | 3 | Bob |
4 | 3 | Tina |
Opportunity | Account | Stage |
4 | 1 | Open |
Contact | Account | Name |
3 | 1 | Mary |
5 | 1 | Tim |
Opportunity | Account | Stage |
5 | 2 | Closed |
Contact | Account | Name |
2 | 2 | John |
<colgroup><col><col span="2"></colgroup><tbody>
</tbody>