I'm not sure how to best explain this, so I'll use a basic example of what I'm trying to accomplish.
We have trucks that deliver product 2-3 times a week. One truck will have all the same product on it. I'd like to have a table that populates so it's easy for me to see what parts are arriving by day.
What I currently have is in a list like this:
I'd like to convert it into something like this (arrival dates going across):
Is there a formula that will allow me to do this? I tried VLOOKUP/Match and INDEX/Match and couldn't get anything that was accurate.
Appreciate your help!
We have trucks that deliver product 2-3 times a week. One truck will have all the same product on it. I'd like to have a table that populates so it's easy for me to see what parts are arriving by day.
What I currently have is in a list like this:
Part | Arrival | Truck |
A | 8-Sep | 1234 |
A | 13-Sep | 6767 |
D | 13-Sep | 9999 |
C | 15-Sep | 6543 |
C | 11-Sep | 7878 |
B | 9-Sep | 3456 |
I'd like to convert it into something like this (arrival dates going across):
Part | 8-Sep | 9-Sep | 10-Sep | 11-Sep | 12-Sep | 13-Sep | 14-Sep | 15-Sep | 16-Sep |
A | 1234 | 6767 | |||||||
B | 3456 | ||||||||
C | 7878 | 6543 | |||||||
D | 9999 |
Is there a formula that will allow me to do this? I tried VLOOKUP/Match and INDEX/Match and couldn't get anything that was accurate.
Appreciate your help!