pivot table issue -- putting data of the same code on diff lines

N

natey

i have an issue with excel that is very hurtfu

i'll put together a table with say the first column having a range of dates or perhaps keyword

second column would have product codes (often repeating product codes referring to a different column one date or keyword

third column would have numbers as in number of cases sol

then i'll make a pivot tabl

and items that have different column a values but like column b values appear on different row

THIS DRIVES ME INSANE PLEASE HELP ME
 
Top