To start off, I don’t really use Excel, but I was given this task.
We are integrating two stores (CRUNCH and FRESH) into our MAIN system, each with their own client formatting. Many clients are shared between all three stores, but the goal is to condense the data into one row, populating data in the necessary column.
In the Example Data set, Apple Candy is the customer and there are three entries from different origins. The customer name is formatted differently in each row and there is a second location. Columns H-J are specific to their origin.
The Goal is to condense all the data for one customer and keep it on one row. So all Apple Candy customer data would be limited to row 2, and the client numbers from each origin would populate into row 2. IF the address is different, a second entry could be added. The ideal scenario would look like this desired data set
The real data set has +9000 rows and 45 columns. What is the easiest and quickest way to complete this task.
