Hi,
I have 15000 raw data as per below , Column A contain different id there home address split in column b (A,B,C,D) i want output in first cell of C column (ABCD) agints each id.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col width="64" span="3" style="width:48pt"></colgroup><tbody>
</tbody>
I have 15000 raw data as per below , Column A contain different id there home address split in column b (A,B,C,D) i want output in first cell of C column (ABCD) agints each id.
Column A | Column B | Column C |
Id | Address | O/P |
OT001 | A | ABCD |
B | ||
C | ||
D | ||
PTT001 | F | FG |
G |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col width="64" span="3" style="width:48pt"></colgroup><tbody>
</tbody>