If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|