Hi,
Colum A and B contain code. I need code row to column without duplication.
I prefer non array formula solutions.
Any much appreciated.
<colgroup><col width="64" style="width: 48pt;"><colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"><tbody>
</tbody>
<colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"><colgroup><col width="64" style="width: 48pt;" span="6"><tbody>
</tbody>
Colum A and B contain code. I need code row to column without duplication.
I prefer non array formula solutions.
Any much appreciated.
CODE A | CODE B |
111 | 7879 |
111 | 7879 |
111 | |
111 | 556 |
556 | |
333 | |
333 | 557 |
333 | |
111 | |
6765 | |
6765 | 889 |
6765 | 889 |
6765 | 889 |
6765 | |
786 | |
889 | 786 |
889 | 786 |
889 | 786 |
889 | 786 |
<colgroup><col width="64" style="width: 48pt;"><colgroup><col width="63" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2304;"><tbody>
</tbody>
DESIRED RESULT | ||||||
CODE A | 111 | 333 | 6765 | 889 | ||
CODE B | 7879 | 556 | 557 | 111 | 889 | 786 |
<colgroup><col width="119" style="width: 89pt; mso-width-source: userset; mso-width-alt: 4352;"><colgroup><col width="64" style="width: 48pt;" span="6"><tbody>
</tbody>