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 |