Have you ever struggled with modifying your Excel document while on the go? Well, DocHub comes with an excellent solution for that! Access this online editor from any internet-connected device. It allows users to Join guide in Excel files rapidly and whenever needed.
DocHub will surprise you with what it offers. It has robust functionality to make whatever changes you want to your forms. And its interface is so straightforward that the entire process from beginning to end will take you only a few clicks.
After you complete adjusting and sharing, you can save your updated Excel file on your device or to the cloud as it is or with an Audit Trail that includes all modifications applied. Also, you can save your paperwork in its original version or turn it into a multi-use template - complete any document management task from anywhere with DocHub. Sign up today!
so I have two data sets two sheets with two different data set and I want to join these two data sets together in Excel we could use vlookup but if there is a repetition and then we look up unfortunately it doesnt work convert this table my table has a header and you do the same thing and youll see this you have to do the same thing the table rains these together do we do that Manish berries manage queries mums very much varies much very just new and you want much country list with this and you could choose all the type of joins I will go with full outer join you have to select the columns so this is the column join condition and click OK we get a new table which you merge table if the data type doesnt match could complain yeah could change the data type by right clicking change type as whatever text so this current here maybe much might complain so I could change its matching so now you could maybe say again keep youll see of merge data set yeah its suspecting and what I do okay