Extend the number of unique keys in a table

Hello everyone,

I hope there is someone out there who can help with the follwoing problem.

I have table containg 2 primary keys (From Warehouse and Delivery Method).

From Warehouse-Delivery Method Lead Time

US D001 x
US D002
US D003
US D004
US D005
etc etc

This table how now changed to including 3 primary keys:


From Warehouse-Delivery Method-To Warehouse

US D001 Sweden
US D002 Sweden
US D003 Sweden
US D004 Sweden
US D005 Sweden
US D001 Germany
US D002 Germany
US D003 Germany
US D004 Germany
US D005 Germany
US D001 ITALY
US D002 ITALY
US D003 ITALY
US D004 ITALY
US D005 ITALY
US D001 CANADA
US D002 CANADA
US D003 CANADA
US D004 CANADA
US D005 CANADA
etc etc etc

What I want to do is per unique From Warehouse-Delivery method be able to add To Warehouse values so they table looks like above. is this possible?

Sorry, I am not sure, are you asking for a macro that will do this? all I see is a sheet with some data. isn't column D-F exacly what you you are asking for, just with "A01" as "from warehouse" instead of "US"?

Do you mean K1 & K2 & K3?

US D001 SWEDEN
US D002 SWEDEN
US D003 SWEDEN
US D004 SWEDEN
US D005 SWEDEN
US D006 SWEDEN
US D007 SWEDEN
US D008 SWEDEN
US D009 SWEDEN
US D010 SWEDEN
US D011 SWEDEN
US D012 SWEDEN
US D013 SWEDEN
US D014 SWEDEN
US D015 SWEDEN
US D016 SWEDEN
US D017 SWEDEN
US D001 GERMANY
US D002 GERMANY
US D003 GERMANY
US D004 GERMANY
US D005 GERMANY
US D006 GERMANY
US D007 GERMANY
US D008 GERMANY
US D009 GERMANY
US D010 GERMANY
US D011 GERMANY
US D012 GERMANY
US D013 GERMANY
US D014 GERMANY
US D015 GERMANY
US D016 GERMANY
US D017 GERMANY
US D001 UK
US D002 UK
US D003 UK
US D004 UK
US D005 UK
US D006 UK
US D007 UK
US D008 UK
US D009 UK
US D010 UK
US D011 UK
US D012 UK
US D013 UK
US D014 UK
US D015 UK
US D016 UK
US D017 UK
US D001 ITALY
US D002 ITALY
US D003 ITALY
US D004 ITALY
US D005 ITALY
US D006 ITALY
US D007 ITALY
US D008 ITALY
US D009 ITALY
US D010 ITALY
US D011 ITALY
US D012 ITALY
US D013 ITALY
US D014 ITALY
US D015 ITALY
US D016 ITALY
US D017 ITALY

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Ok I have looked at this again

You have an existing excel table with two keys.

You now want to add a third key. So left click in the table, right click and select insert column to the right.

Now you can paste your new column data into the third column.

Please find the attached sheet and click on the Green Button to run the code to see if this is what you are trying to achieve.

Please find the attache sheet.

See the attached.

You're welcome.