Hi,
I have customer data in multiple excel sheets and i need to consolidate them in one excel sheet. Customer details in each excel sheet are different but headers are common in all sheets. How can I do this?
Ex: Workbook1
Cust ID | Cust Name | Loc |
234 | XYZ | US |
Ex: Workbook2
Cust ID | Cust Name | Loc |
435 | UIH | IN |
Ex: Workbook3
Cust ID | Cust Name | Loc |
456 | OIU | UH |
Expected Result/workbook:
Cust ID | Cust Name | Loc |
234 | XYZ | US |
435 | UIH | IN |
456 | OIU | UH |
Solved! Go to Solution.
Thank you. I was able to do it by Union Tool.