How to combine 2 sheets with duplicate data in one column keeping all data from both sheets
I have 2 sheets of data in an Excel workbook. In sheet 1, I have rows of data consisting of 3 columns with a UPC number in column A, cost in column B, and retail price in column C. in sheet 2, I have the same UPC codes in column A and a Item count in column B. I need to combine the 2 sheets so that I have 1 sheet with 4 columns consisting of UPC code, cost, retail price and item count. Is there a formula or operation that I can run that will combined the 2 sheets this way?
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago