Excel list based on criteria

[helen.m]

Hello,
I have a list of data in the following format:

Col A	Col B
Cty1	Step 1 Cty1
Cty1	Step 2 Cty1
Cty1	Step 3 Cty1
Cty1	Step 4Cty1
Cty 2	Step 1 Cty 2
Cty 2	Step 2 Cty 2
Cty 2	Step 3 Cty 2
Cty 2	Step 4 Cty 2

I need to sort it so that I get in the following format:

Col A	Cty1	Cty2
Step 1	Step 1 Cty1	Step 1 Cty2
Step 2	Step 2 Cty1	Step 2 Cty2
Step 3	Step 3 Cty1	Step 3 Cty2
Step 4	Step 4 Cty1	Step 4 Cty2

I have tried a couple of formulas but I cannot seem to get it working. It either keeps pulling back the same value or it ignores whether it is Cty1 or Cty2 and pulls back everything in the list.

Any ideas?

[Syrkrasi]

Try these formulas

Formulas
Column A: IFERROR(IF(LEFT(B21,4)=LEFT(C21,4),LEFT(B21,6),""),"")
Column B: IFERROR(INDEX($A$2:$B$11,SMALL(IF($A$2:$A$11="cty1",ROW($A$2:$A$11)),ROW(1:1))-1,2),"")
Column C: IFERROR(INDEX($A$2:$B$11,SMALL(IF($A$2:$A$11="cty 2",ROW($A$2:$A$11)),ROW(1:1))-1,2),"")

See attachment

[Syrkrasi]

Updated attachment