Need help with find and replace/append
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you @AkimasaKajitani and @Qiu This is exactly what I was looking for, you guys made it look very easy lol. Thanks again!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad to help and thank you for the accept mark.
