# Index, row, columns and matching

#### grimeyway

##### New Member
• <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.

sample posted below, showing the raw and what the final should hopefully look like.​
</article>
https://onedrive.live.com/redir?resid=717CF2225B71C47D!584&authkey=!AAgMPgMv710NHZI&ithint=file,xlsx

### Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Welcome Grimeyway,

You can try this:

Excel 2010
AFSTUVWX
1Raw data
2Sub-ListSKUMarketDisc %
3504612345MDL Stock61
4504612345Mass Market55
5504612345Special Sales61
6504612345HC Over One Pallet61
7504612345Export70
9504656789Mass Market55
10504656789Special Sales0
11504656789HC Over One Pallet0
12504656789Export0
135046345670
14
15Final data
16Sub-ListSKUTradeMDL StockMass MarketSpecial SalesHC Over One PalletExport
17504612345 6155616170
185046567895855000
19504634567
Sheet1
Cell Formulas
RangeFormula
F4=+IF(E3=E4,F3,0)
F9=+IF(E8=E9,F8,0)

Best,

Luke

Replies
2
Views
205
Replies
6
Views
809
Replies
8
Views
417
Replies
2
Views
493
Replies
1
Views
713

1,203,327
Messages
6,054,751
Members
444,748
Latest member
knowak87

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back