I have created a series of spreadsheets to help my daughter in her role as a
part-time Avon rep. Generally, everything works fine but I am stuck in one
particular area. Each 3 week period (campaign) her customers order roughly
200 items. I type these into a sheet and then use the Pivot Table wizard to
produce a summary of the item numbers and quantity of each required. The
problem is that I can't manipulate the ouput from the Pivot Table so is
there a different way to produce a summary? The reason I want to use the
data is that I have another sheet with 19 columns (A is the item number and
the rest are the 18 annual campaign numbers). I input (manually) the item
numbers with the quantity ordered at the bottom of this master sheet, then
sort it by item number so that I have duplicate item numbers in column A
with quantities under various campaign numbers. I want to merge this data so
that I only have 1 row for each item number. For example, row 1 shows item
12345 in column A then each of the related 18 columns will have the quantity
of item 12345 ordered for that campaign. Can anybody tell me if there is a
way to merge the rows using code please?

Regards,

Peter