Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to count based on different criteria in two columns | Excel Worksheet Functions | |||
Delete rows based on criteria | Excel Discussion (Misc queries) | |||
get a total based on criteria in two columns | Excel Worksheet Functions | |||
Transpose rows to columns w/varying numbers of lines per record | Excel Worksheet Functions | |||
Sum based on criteria in rows and columns | Excel Discussion (Misc queries) |