Hi

would anyone know how to do the following

I have hundreds of rows of data in the following several columns as per below

reference number| type | qty | value |

The reference number is unique but there can be several rows with the same
reference number. Type changes between 6 criterias (A,B,C,D,E,F) , qty
varies, value varies.

I need to be able to put data into columns to insure one row = one reference
number with the data displayed as per the 6 type criterias.

reference number | type A |type B| qty A | qty B | value A| value B|

can anyone help? pivot table or is there a better way??
thanks