Sep 24 2020 05:59 AM
Hi
Information:
I'm using Excel 2010, there are 1000+rows.
I have 2 excel sheets and I have reducted the needed Data down to 3 different ones.
On sheet 1, I have in column A all the product "NAMES" and in column B their respective "QUALITY"
In sheet 2, I have in column A again all the "NAMES" and in column B their respective "WEIGHT"
I would like to do 2 things in one go: Merge these 4 columns onto 1 sheet while allocating e.g. the "WEIGHT" onto the respective row where its counterpart "NAME" is, so I'm only left with "NAME", "QUALITY" AND "WEIGHT".
The order of the above mentioned data sets don't matter.
Thank you in advance.
Sep 24 2020 06:10 AM
Hi @Uguey,
If your sheet1 and sheet2 have the exact same names in your "NAMES" column, how about you simply sort them in alphabetical order, copy the weight column from sheet2 and paste it to sheet1?
This will work fine if and only if you have the exact same NAMES column in both sheet.
Sep 24 2020 06:13 AM
Also, I suggest you upgrade from Office 2010 to the latest.
Office 2010 will reach end of support on October 13 2020. Meaning it will not receive security patches anymore and will leave your system vulnerable.
Sep 24 2020 06:31 AM
Sep 24 2020 06:40 AM