Thread: How do I consolidate multiple records into one?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Midalia Midalia is offline
external usenet poster
  
Posts: 1
Default How do I consolidate multiple records into one?
I have a worksheet that has approx. 150 rows and 10 columns that contains
some rows with multiple duplicate data, but the cost column has different
costs that need to consolidated into one record in order to import to Access
correctly. Please assist with this work in process.


3618130823 22-Jul Equipment Tax $9.48
3618130823 22-Jul Equipment Shipping & Handling $14.95

Reply With QuoteReply With Quote