In my workbook there are 2 columns A and B
I want to make a column C where B is the same as A
A B
1 4
2 7
3 8
4 5
5 9
The output needs to be
A B C
1 4 5
2 7 null
3 8 null
4 5 9
5 9 null
I hope someone can help me.
3 answers
Hi @Gerbrich Eisma ,
You have to implement the following steps:
1) Join the the data to itself.
2) Configure the join to be A = B(Copy)
3) Make sure is a LEFT join
4) Hide A(Copy)
5) Rename B(Copy) as C
Hope this helps!
Best,
Diego
