Hi, i have a problem here.
I have a huge list of data, with 9 columns: Date, A,B,C,D,E,F,G,H
I copied 2 set of Data (Date,A,B,C) and (Date,D,E,F,G,H) into 1 sheet together
After adding everything and filtering them by date, i have repeated dates, but some with data only in A,B,C and with the same date, only in C,D,E,F,G
eg:
date----------A-----B-----C------D------E------F------G------H
5/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
5/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
8/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
9/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
12/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
12/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
.
.
.
1.5k rows
I was wondering if there is a macro to combine all the repeated date cells data together into all 8 columns filled, while leaving the singular ones alone.
eg.
date----------A-----B-----C------D------E------F------G------H
5/3/2011-----10-----20-----30-----30-----50-----60-----10-----50
8/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
9/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
12/3/2011-----10-----20-----30-----30-----50-----60-----10-----50
.
.
.
1.5k rows
Any idea?
Thanks!
I have a huge list of data, with 9 columns: Date, A,B,C,D,E,F,G,H
I copied 2 set of Data (Date,A,B,C) and (Date,D,E,F,G,H) into 1 sheet together
After adding everything and filtering them by date, i have repeated dates, but some with data only in A,B,C and with the same date, only in C,D,E,F,G
eg:
date----------A-----B-----C------D------E------F------G------H
5/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
5/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
8/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
9/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
12/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
12/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
.
.
.
1.5k rows
I was wondering if there is a macro to combine all the repeated date cells data together into all 8 columns filled, while leaving the singular ones alone.
eg.
date----------A-----B-----C------D------E------F------G------H
5/3/2011-----10-----20-----30-----30-----50-----60-----10-----50
8/3/2011-----10-----20-----30-----__-----__-----__-----__-----__
9/3/2011-----__-----__-----__-----30-----50-----60-----10-----50
12/3/2011-----10-----20-----30-----30-----50-----60-----10-----50
.
.
.
1.5k rows
Any idea?
Thanks!
Last edited: