categorising columns into rows

[guerilla]

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

[steven1001]

this post talks about converting multiple columns of info into a single column so it can be used in a pivot table. although the post talks about using access you can do the same thing with msquery and data in a spreadsheet.
regards..

http://www.excelforum.com/showthread...ighlight=union