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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago