Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I consolidate multiple records into one?
To add all the A1 cells in Sheet1 to Sheet10 use
=SUM(Sheet1:Sheet10!A1) Any help? best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Midalia" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I consolidate multiple records into one?
Here is a similar example using
Excel 2007 and Tables. It consolidates rows with the same initial columns. http://www.savefile.com/files/1867194 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to consolidate multiple worksheets into one. | Excel Discussion (Misc queries) | |||
Consolidate multiple cells into one | Excel Worksheet Functions | |||
Consolidate multiple worksheets into new sheet | Excel Worksheet Functions | |||
Consolidate multiple workbooks | Excel Worksheet Functions | |||
Is there a function to consolidate multiple records into one recor | Excel Worksheet Functions |