Every week I pull a report from a CRM (Report 1) and then a separate report from a program that records our internet activity (report 2).
Report 1: Shows a customers name, stock number, deal stage, date created and date of last engagement.
<tbody>
</tbody>
Report 2: Shows the stock number, Make, Model, VDP Views, avg VDP views per day
<tbody>
</tbody>
End Goal: Combine the two reports so that I can sort the data by using a simple pivot table. Is there a way for me to look at the column containing the stock number in report 1 (column B) and if there is a match (there will be multiple matches for the same stock number) I would like data in columns B,C,D,E from report 2 to be added to columns F,G,H,I in Report 1?
<tbody>
</tbody>
Thank you for the help. Please let me know if this is unclear
Report 1: Shows a customers name, stock number, deal stage, date created and date of last engagement.
Customer | Stock # | Stage | Created | Engaged |
John S | 456789 | Visit | 9/1/17 | 9/5/17 |
Dwight R | TMK425 | Proposal | 9/2/17 | 9/4/17 |
<tbody>
</tbody>
Report 2: Shows the stock number, Make, Model, VDP Views, avg VDP views per day
Stock # | Make | Model | VDP Views | Avg VDP Per Day |
456789 | BMW | 3 | 3 | 1.50 |
TMK425 | Chevy | Impala | 1 | 1 |
<tbody>
</tbody>
End Goal: Combine the two reports so that I can sort the data by using a simple pivot table. Is there a way for me to look at the column containing the stock number in report 1 (column B) and if there is a match (there will be multiple matches for the same stock number) I would like data in columns B,C,D,E from report 2 to be added to columns F,G,H,I in Report 1?
Customer | Stock # | Stage | Created | Engaged | Make | Model | VDP Views | AVG VDP Per Day |
John S | 456789 | Visit | 9/1/17 | 9/5/17 | BMW | 3 | 3 | 1.5 |
Dwight R | TMK425 | Proposal | 9/2/17 | 9/4/17 | Chevy | Impala | 1 | 1 |
<tbody>
</tbody>
Thank you for the help. Please let me know if this is unclear