I have this table : 

```
PRODUCTNUMBER   AttributeTypeName               TextValue
1020M              Core Style                    Fashion
1020M               Length/Weight                 LONG
1020M              Quilted/NonQuilted             NonQuilted

```

I want to create a query to give me this table 

```
 AttributeTypeName = Core Style --> TextValue  Stylecode
 AttributeTypeName =Quilted/NonQuilted  --> TextValue  FabricCategory
 AttributeTypeName =Length/Weight  --> TextValue  LableCode

```

I am using case but I am getting 3 rows for each item and i want to see just 1 row like this

```
PRODUCTNUMBER   Stylecode    FabricCategory      LableCode

1020M             Fashion       NonQuilted       LableCode

```