How do I consolidate multiple records into one?

M

Midalia

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
 
B

Bernard Liengme

To add all the A1 cells in Sheet1 to Sheet10 use
=SUM(Sheet1:Sheet10!A1)
Any help?
best wishes
 
Top