I have two tables, column Code is in both tables, and I need to create third table where Code is common column and ofcourse the rest columns from both tables.
How to do that ?
I tried with pivot table but didnt succeed.
Example attached.
I have two tables, column Code is in both tables, and I need to create third table where Code is common column and ofcourse the rest columns from both tables.
How to do that ?
I tried with pivot table but didnt succeed.
Example attached.
With VLookup.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
thank you very much for all your help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks