tytrogdon987
New Member
- Joined
- Dec 15, 2016
- Messages
- 3
I have two columns in which I need to concatenate the data from each column alternately into one cell.
<tbody>
</tbody>
Expected result: 12OR34OR56OR78OR90
There are over 1000 rows per column and I am having a hard time finding an efficient way to use concatenate if that is even the best way to approach this problem.
Your help is greatly appreciated!
Column A | Column B |
12 | OR |
34 | OR |
56 | OR |
78 | OR |
90 | OR |
<tbody>
</tbody>
Expected result: 12OR34OR56OR78OR90
There are over 1000 rows per column and I am having a hard time finding an efficient way to use concatenate if that is even the best way to approach this problem.
Your help is greatly appreciated!