I have an excel database where each line represents an entity and it's data over about 70 columns. There are multiple occurrences of delivery information in these columns that I need to summarize in a pivot table. Some lines may have only one occurrence of this delivery while some others may have three or four.
Please see my example attached. Thank you for your continuing help. John -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Pivot Table Help.xls
Description: MS-Excel spreadsheet