- <article>I have some raw information, which has different information about the same product across a few rows, I need to take just one SKU for each product but then move some of the information that’s in the rows onto one row, so in the example I have the column marked market for each product, it is this info that needs to come onto one row. The number of rows for each sku will then be reduced, the products though the same are differentiated from each because of the SKU therefore I need to take each sku and then get the market info for it one one row, I have 10K lines to get through, please help. I have tried to be clear if I haven't please don't hesitate to ask any questions. Thanks in advance.</article>
sample posted below, showing the raw and what the final should hopefully look like.