Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidating data
Hi,
I need to consolidate some lines of data in a 19K line spreadsheet and then change its basic format. I have 3 columns of data: ID# | date | volume My problem is that while the data is mostly monthly, there are some months with two entries and I need to consolidate them into a single monthly value. I don't care which of the dates is used as long as the month and year are correct. That's the 'consolidate' part. Then I need to convert the 19,000 row spreadsheet to a big grid with the meters listed in the left row and the month/year at the top of each column with the appropriate volumes in the body of the table. This is the 'format' part and I suspect that I can use Access to do this, but I thought I would ask for input here, too. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating Data | Excel Discussion (Misc queries) | |||
Consolidating Data | Excel Worksheet Functions | |||
consolidating data | Excel Discussion (Misc queries) | |||
Consolidating Data | Excel Discussion (Misc queries) | |||
Consolidating data?? | Excel Worksheet Functions |