INDEX/MATCH Help

gbdenisse · Nov 4, 2015

I have the following scenario

[TABLE="width: 500"]
<tbody>[TR]
[TD]Package SKU[/TD]
[TD]Individual SKU[/TD]
[/TR]
[TR]
[TD]8000P[/TD]
[TD]12345[/TD]
[/TR]
[TR]
[TD]8000P[/TD]
[TD]12370[/TD]
[/TR]
[TR]
[TD]8001P[/TD]
[TD]12345[/TD]
[/TR]
[TR]
[TD]8001P[/TD]
[TD]12350[/TD]
[/TR]
[TR]
[TD]8001P[/TD]
[TD]12382[/TD]
[/TR]
</tbody>[/TABLE]

I want my data to look like this, I need help with bringing the individual SKUs across columns so that each row is unique.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Unique Package SKU[/TD]
[TD]Individual SKU 1[/TD]
[TD]INDIVDUAL SKU 2[/TD]
[TD]INDIVIDUAL SKU3[/TD]
[/TR]
[TR]
[TD]8000P[/TD]
[TD]12345[/TD]
[TD]12370[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8001P[/TD]
[TD]12345[/TD]
[TD]12350[/TD]
[TD]12382[/TD]
[/TR]
</tbody>[/TABLE]

I tried using INDEX MATCH but I can drag the formula across columns only down..Help!

Weazel · Nov 4, 2015

maybe something like...

B9=IFERROR(INDEX($B$2:$B$6,SMALL(IF($A$2:$A$6=$A9,ROW($A$2:$A$6)-ROW($A$2)+1),COLUMNS($B9:B9))),"") control shift enter

[TABLE="class: grid"]
<tbody>[TR]
[TD]Row\Col[/TD]
[TD]

A

[/TD]
[TD]

B

[/TD]
[TD]

C

[/TD]
[TD]

D

[/TD]
[/TR]
[TR]
[TD]

1

[/TD]
[TD]Package SKU[/TD]
[TD]Individual SKU[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

2

[/TD]
[TD]8000P[/TD]
[TD]

12345