K
Ken DeYoung - Educational Consultant
I am trying to consolidate records in excel or access whichever will turn out
to be easier. The problem is that these records come from a number of
diffeent databases. They almost all have similar column headings but some
duplicate info and some not. I am looking to consolidiate the simlar unique
IDs eliminating duplicate info for some colums but not for all.
Below is an example of a before and after scenerio. I am assuming that this
will require macros but I am not very good at the coding.
Format I recieve the data in
ID Name Term Test Score
35615 Mike Ramos Fall Math 125
35615 Mike Ramos Winter Math 115
35615 Mike Ramos Fall Reading 125
Final outcome desired
ID Name Term1 Test1 Score1 Term2 Test2 score2 Term3
Test3.....
35615 Mike R. Fall Math 125 Winter Math 115
Fall 125
It does not have to be as spread out as that but the idea is taking multiple
data entries for the same unique ID and make one entry.
If I was only dealing with a few entries i could do it manually but I am
working with a couple thousand students each of which have at least 6 data
lines with at least . Thanks in advance for any assistance in this endevor.
Ken DeYoung
to be easier. The problem is that these records come from a number of
diffeent databases. They almost all have similar column headings but some
duplicate info and some not. I am looking to consolidiate the simlar unique
IDs eliminating duplicate info for some colums but not for all.
Below is an example of a before and after scenerio. I am assuming that this
will require macros but I am not very good at the coding.
Format I recieve the data in
ID Name Term Test Score
35615 Mike Ramos Fall Math 125
35615 Mike Ramos Winter Math 115
35615 Mike Ramos Fall Reading 125
Final outcome desired
ID Name Term1 Test1 Score1 Term2 Test2 score2 Term3
Test3.....
35615 Mike R. Fall Math 125 Winter Math 115
Fall 125
It does not have to be as spread out as that but the idea is taking multiple
data entries for the same unique ID and make one entry.
If I was only dealing with a few entries i could do it manually but I am
working with a couple thousand students each of which have at least 6 data
lines with at least . Thanks in advance for any assistance in this endevor.
Ken DeYoung