P
powderskier9
Hello,
I have a problem that needs to be solved in Excel. I have two column
of data, and need to align the information in one column(B), with th
information in another(A).
For example:
Column A Col B
CODE1 CODE4
CODE2 CODE27
CODE3 CODE45
CODE4
onto CODE45
This does not work with a simple data sort since there are space
between the values in Column B that need to be aligned with the correc
row in Column A. Currently the company manually copies and then paste
the correct value in Column B to the correct position in Column B tha
is aligned with its match in Column A.
Cheers and thanks for the help,.
Mar
I have a problem that needs to be solved in Excel. I have two column
of data, and need to align the information in one column(B), with th
information in another(A).
For example:
Column A Col B
CODE1 CODE4
CODE2 CODE27
CODE3 CODE45
CODE4
onto CODE45
This does not work with a simple data sort since there are space
between the values in Column B that need to be aligned with the correc
row in Column A. Currently the company manually copies and then paste
the correct value in Column B to the correct position in Column B tha
is aligned with its match in Column A.
Cheers and thanks for the help,.
Mar