| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to combine data based on two fields..
Let's say that you have a spreadsheet with three fields, like:
Year Group Value 1970 1 3 1970 1 1 1972 1 1 1973 1 5 1974 1 2 1974 1 0 1974 1 2 1970 2 1 1970 2 1 1973 2 2 1975 2 3 1975 2 5 What I want is to combine all values for a given group in a single year. So for instance, the above spreadsheet would become: Year Group Value 1970 1 4 1972 1 1 1973 1 5 1974 1 4 1970 2 2 1973 2 2 1975 2 8 Any help on where to look as far as excel 2003 commands would be appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to combine data based on two fields..
A pivot table would be ideal...
http://peltiertech.com/Excel/Pivots/pivotstart.htm -- HTH... Jim Thomlinson "gambler1650" wrote: Let's say that you have a spreadsheet with three fields, like: Year Group Value 1970 1 3 1970 1 1 1972 1 1 1973 1 5 1974 1 2 1974 1 0 1974 1 2 1970 2 1 1970 2 1 1973 2 2 1975 2 3 1975 2 5 What I want is to combine all values for a given group in a single year. So for instance, the above spreadsheet would become: Year Group Value 1970 1 4 1972 1 1 1973 1 5 1974 1 4 1970 2 2 1973 2 2 1975 2 8 Any help on where to look as far as excel 2003 commands would be appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine rows with similar data, but different fields in excel | Excel Discussion (Misc queries) | |||
| How to combine data files with different fields? | New Users to Excel | |||
| How do I count based on conditions on two fields in data? | Excel Discussion (Misc queries) | |||
| Adding multiple data fields from time based data. | Excel Discussion (Misc queries) | |||
| combine 2 tables of data into one based on date | Excel Worksheet Functions | |||
Linear Mode
