The data information of the two tabs is combined together

time：2025-01-27 15:03:04 Tech Trends

How to merge data in 2 excel sheets?

When we use excel sheets, sometimes we can't get complete data, we can only get 2 or more points of table data through different channels, sometimes some data is related, you can merge two associated table data into a table, if the data is relatively small, you can copy and paste, if the amount of data is very large, how to merge the two associated table data together in a quick way?

1. First open 2 excel sheets (1, Figure 2), you will find that the A column of these two excel sheets is of the same type, both are "Baidu ID number", the difference is that table 1 has the number of experience and wealth value, and table 2 has the number of experience red envelopes recently, and now you need to merge excel into one table.

2. Column D of Table 1 can now be written with the column headers that need to be imported, or you can copy and paste it directly from Table 2.

3. Then move your mouse to the second row of column D, open the "Formulas" option in the menu bar, find "Insert Function" in the formula's tools and click on it.

# Tech Trends #

《The data information of the two tabs is combined together》 This does not represent the views of this website. If there is any infringement, please contact us to delete it.

Latest article

Recommend

Ranking