I have the following table showing the number of times 2 different products are related, and the match %.
What I want (or to be more accurate, what has been asked of me) is for each Product A to be listed only one time and for the Product B Data to be listed horizontally. So for Product A 10854, I want to add columns listing Prod B, Prod B Desc, Times Related, and Related %, for each of the Prod B items (5028, 4777, 9176). Total of 12 columns added.
Is there a way to do this?
Click to view attachment