Hi,
I'm wondering if anybody can assist me in solving this.
I have 2 columns of numbers. I want to match Col B to Col A and have the matching entries aligned next to one another.
ColA is the "Mater List" and I want to arrange ColB so that ColB's entries align themselves next to ColA's matching entry.
Basically, I am wanting to align matching entries in 2 columns.
Example below.
ColA.............ColB
10................12
14................54
27................10
44................27
98................98
RESULT
ColA.............ColB
10................10
14................
27................27
44................
98................98
...................12
...................54
I'm wondering if anybody can assist me in solving this.
I have 2 columns of numbers. I want to match Col B to Col A and have the matching entries aligned next to one another.
ColA is the "Mater List" and I want to arrange ColB so that ColB's entries align themselves next to ColA's matching entry.
Basically, I am wanting to align matching entries in 2 columns.
Example below.
ColA.............ColB
10................12
14................54
27................10
44................27
98................98
RESULT
ColA.............ColB
10................10
14................
27................27
44................
98................98
...................12
...................54