Need help with find and replace/append

[agrawaluk]

Hi,

I have 2 datasets (attached) and I want to use something similar to vlookup on them to find certain values:

I want to create a matrix with columns as: Unique Zip Code (with 35926 rows of data) and Combination of all zip codes as column header (which means 1023 columns for this). The data for these columns should contain minimum delivery days meaning if dc1 delivers to zipcode1 in 3 days and dc2 delivers to zipcode1 in 4 days then dc1 should be considered in its combination series as well (for eg: while considering combination dc1+dc2 the value against zipcode1 should be 3 days).

The final output table would look something like this:

Zipcode

DC1

DC2

DC3

DC4

DC5

DC6

DC7

DC8

DC9

DC10

DC1 + DC2

…

Under DC columns the minimum delivery days need to be filled in. Also, the sequence of combinations of column headers from this does not matter. 

The data should have 35926 rows and 1025 columns. 

My language here might be confusing so please do not hesitate to ask any question you might have. 

[AkimasaKajitani · Accepted solution]

I made the solution for you.

Oh, Very large records!

And if you want to know minimum ship date, I recommend to get the minimum dates before the CrossTab tool.

[Qiu · Accepted solution]

@agrawaluk 

Agree with @AkimasaKajitani , large data

[agrawaluk]

Thank you @AkimasaKajitani and @Qiu This is exactly what I was looking for, you guys made it look very easy lol. Thanks again!

[Qiu]

@agrawaluk 

Glad to help and thank you for the accept mark.