columns to rows based on record criteria
 

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

columns to rows based on record criteria
 

I think a pivot table is your best option. Select any cell in your data, then
select Data Pivot table. Use the wizard to create an empty shell pivot
table on a new sheet. Drag Reference Number to the row area and Type to the
column area. Drag Qty, then Value to the data area. In my Excel (2003), a
shaded Data label appears next to the Type label. Drag the Type label to the
left of the Data label. This gives Qty and Value grouped by Type, with one
row per Reference Number.

Hope this helps,

Hutch




"AA81" wrote:

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