How to populate table from list?

[bcurrey]

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:

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!

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[bcurrey]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Will do! Thanks for mentioning it. I'm using a Mac and have 365 subscription.

 

[Fluff]

Thanks for that. How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I	J
1	Part	Arrival	Truck
2	A	08-Sep	1234
3	A	13-Sep	6767
4	D	13-Sep	9999
5	C	15-Sep	6543
6	C	11-Sep	7878
7	B	09-Sep	3456
8
9
10
11
12
13	Part	08-Sep	09-Sep	10-Sep	11-Sep	12-Sep	13-Sep	14-Sep	15-Sep	16-Sep
14	A	1234					6767
15	B		3456
16	C				7878				6543
17	D						9999
Lists

Cell Formulas
Range	Formula
B14:J17	B14	=FILTER($C$2:$C$7,($A$2:$A$7=$A14)*($B$2:$B$7=B$13),"")