shan
07-26-2015, 10:38 PM
Hello ,
Good Morning..
Request your assistance on below.
I have data in multiple column. Would like to combine the column if sum of column is same.
If sum of B column is matching with any column then want to club the data and remaining keep as it is....
Note: No restriction on column and rows.
Raw data:
A B C D E F G H I J K L
BJA
HKK
ISR
JKK
KHA
KUA
MNK
SEA
SHR
SIE
TYW
FB
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
BCR2J
10%
10%
10%
9%
10%
10%
6%
7%
10%
0%
10%
BCR3J
10%
10%
10%
9%
10%
10%
6%
7%
10%
0%
10%
CCR2J
12%
12%
12%
10%
12%
10%
8%
9%
12%
10%
12%
CCR3J
12%
12%
12%
10%
12%
10%
8%
9%
12%
10%
12%
DCR2J
10%
10%
10%
9%
10%
12%
9%
7%
10%
12%
14%
DCR3J
10%
10%
10%
9%
10%
12%
9%
7%
10%
12%
14%
HCR2J
10%
10%
10%
9%
10%
10%
5%
7%
10%
10%
7%
HCR3J
10%
10%
10%
9%
10%
10%
5%
7%
10%
10%
7%
JCR2J
12%
12%
15%
10%
15%
10%
10%
9%
12%
10%
12%
JCR3J
12%
12%
15%
10%
15%
10%
10%
9%
12%
10%
12%
KCR2J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
7%
KCR3J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
7%
LCR2J
5%
LCR3J
5%
MCR2J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
5%
MCR3J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
5%
QCR2J
9%
9%
7%
7%
7%
10%
5%
5%
9%
12%
5%
QCR3J
9%
9%
7%
7%
7%
10%
5%
5%
9%
12%
5%
YCR2J
10%
10%
10%
9%
10%
10%
6%
7%
10%
10%
10%
YCR3J
10%
10%
10%
9%
10%
10%
6%
7%
10%
10%
10%
Output:
If you see in above data sum of column B,C and J is same, also sum of column D and F also same hence we need to combine data of B,C and J as in one column and D & F in one column. Rest column will remain as it is.
Combine column highlighted below
BJA HKK SHR
ISR KHA
JKK
KUA
MNK
SEA
SIE
TYW
FB
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
BCR2J
10%
10%
9%
10%
6%
7%
0%
10%
BCR3J
10%
10%
9%
10%
6%
7%
0%
10%
CCR2J
12%
12%
10%
10%
8%
9%
10%
12%
CCR3J
12%
12%
10%
10%
8%
9%
10%
12%
DCR2J
10%
10%
9%
12%
9%
7%
12%
14%
DCR3J
10%
10%
9%
12%
9%
7%
12%
14%
HCR2J
10%
10%
9%
10%
5%
7%
10%
7%
HCR3J
10%
10%
9%
10%
5%
7%
10%
7%
JCR2J
12%
15%
10%
10%
10%
9%
10%
12%
JCR3J
12%
15%
10%
10%
10%
9%
10%
12%
KCR2J
10%
8%
9%
12%
5%
5%
12%
7%
KCR3J
10%
8%
9%
12%
5%
5%
12%
7%
LCR2J
5%
LCR3J
5%
MCR2J
10%
8%
9%
12%
5%
5%
12%
5%
MCR3J
10%
8%
9%
12%
5%
5%
12%
5%
QCR2J
9%
7%
7%
10%
5%
5%
12%
5%
QCR3J
9%
7%
7%
10%
5%
5%
12%
5%
YCR2J
10%
10%
9%
10%
6%
7%
10%
10%
YCR3J
10%
10%
9%
10%
6%
7%
10%
10%
Regards,
Shan
Good Morning..
Request your assistance on below.
I have data in multiple column. Would like to combine the column if sum of column is same.
If sum of B column is matching with any column then want to club the data and remaining keep as it is....
Note: No restriction on column and rows.
Raw data:
A B C D E F G H I J K L
BJA
HKK
ISR
JKK
KHA
KUA
MNK
SEA
SHR
SIE
TYW
FB
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
BCR2J
10%
10%
10%
9%
10%
10%
6%
7%
10%
0%
10%
BCR3J
10%
10%
10%
9%
10%
10%
6%
7%
10%
0%
10%
CCR2J
12%
12%
12%
10%
12%
10%
8%
9%
12%
10%
12%
CCR3J
12%
12%
12%
10%
12%
10%
8%
9%
12%
10%
12%
DCR2J
10%
10%
10%
9%
10%
12%
9%
7%
10%
12%
14%
DCR3J
10%
10%
10%
9%
10%
12%
9%
7%
10%
12%
14%
HCR2J
10%
10%
10%
9%
10%
10%
5%
7%
10%
10%
7%
HCR3J
10%
10%
10%
9%
10%
10%
5%
7%
10%
10%
7%
JCR2J
12%
12%
15%
10%
15%
10%
10%
9%
12%
10%
12%
JCR3J
12%
12%
15%
10%
15%
10%
10%
9%
12%
10%
12%
KCR2J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
7%
KCR3J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
7%
LCR2J
5%
LCR3J
5%
MCR2J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
5%
MCR3J
10%
10%
8%
9%
8%
12%
5%
5%
10%
12%
5%
QCR2J
9%
9%
7%
7%
7%
10%
5%
5%
9%
12%
5%
QCR3J
9%
9%
7%
7%
7%
10%
5%
5%
9%
12%
5%
YCR2J
10%
10%
10%
9%
10%
10%
6%
7%
10%
10%
10%
YCR3J
10%
10%
10%
9%
10%
10%
6%
7%
10%
10%
10%
Output:
If you see in above data sum of column B,C and J is same, also sum of column D and F also same hence we need to combine data of B,C and J as in one column and D & F in one column. Rest column will remain as it is.
Combine column highlighted below
BJA HKK SHR
ISR KHA
JKK
KUA
MNK
SEA
SIE
TYW
FB
ANN
ANN
ANN
ANN
ANN
ANN
ANN
ANN
BCR2J
10%
10%
9%
10%
6%
7%
0%
10%
BCR3J
10%
10%
9%
10%
6%
7%
0%
10%
CCR2J
12%
12%
10%
10%
8%
9%
10%
12%
CCR3J
12%
12%
10%
10%
8%
9%
10%
12%
DCR2J
10%
10%
9%
12%
9%
7%
12%
14%
DCR3J
10%
10%
9%
12%
9%
7%
12%
14%
HCR2J
10%
10%
9%
10%
5%
7%
10%
7%
HCR3J
10%
10%
9%
10%
5%
7%
10%
7%
JCR2J
12%
15%
10%
10%
10%
9%
10%
12%
JCR3J
12%
15%
10%
10%
10%
9%
10%
12%
KCR2J
10%
8%
9%
12%
5%
5%
12%
7%
KCR3J
10%
8%
9%
12%
5%
5%
12%
7%
LCR2J
5%
LCR3J
5%
MCR2J
10%
8%
9%
12%
5%
5%
12%
5%
MCR3J
10%
8%
9%
12%
5%
5%
12%
5%
QCR2J
9%
7%
7%
10%
5%
5%
12%
5%
QCR3J
9%
7%
7%
10%
5%
5%
12%
5%
YCR2J
10%
10%
9%
10%
6%
7%
10%
10%
YCR3J
10%
10%
9%
10%
6%
7%
10%
10%
Regards,
Shan