Matching data based on Codes but rows duplicating

Hi, 

I have this raw data. I need to be easily see in PBI matches for the codes.  Example in the column category A the Code is 4HVJZU, in the same Category Column there is a match for B, but is is split into 2. When I try and show these side by side looking for matches, difference in No sold etc it is duplicating the A rows to match with the number of Rows in B. Please see second image.

As you can see it has duplicated the A row (highlighted in Red Fill) to match with B having 2 rows of data and has duplicated the No sold, effectively skewing the data. Is there any way that I can stop the duplication of the A rows? Could another column be added to split the B codes? Im drawing a blank!