Hi,

I have many large spreadsheets containing delivery information. The deliveries are categorised in columns, (Wine, lager, soft drinks etc), however I would like to summarise the data in a pivot table, but can only get totals by delivery time if I group all deliveries into one column and use a second to determine the type of drink i.e. "type" equals wine, "quantity" equals 10. I also sometimes have more than one drink type per delivery. Is there an easy way of taking the quanties of each drink and storing them in one column with the type in a second column, without doing this one product at a time, manually. I think I could then get a pivot table to give me an arrival profile per type (as I need to resource crertain areas depending on the type of drink arriving?

regards,

Matt