Combine 2 columns into 1 without changing any data

[Apcvirgo1]

Hi all,

First time at this scenario, using excel input combine 2 columns into 1. The data can change, I've done this in the past when the data is constant in both fields. Tran # represents what I need a tool to do:

Detail Item #	Invoice Item #	Tran #
1		1
	1	1
2		2
	2	2
3		3
	3	3
4		4
	4	4
5		5
	5	5
6		6
	6	6
7		7
	7	7
8		8
	8	8
9		9
	9	9
10		10
	10	10
1		1
2		2
3		3
	3	3
	3	3
	3	3
4		4
5		5
	5	5
	5	5
6		6
7		7
	7	7
	7	7
8		8
9		9
	9	9
	9	9
10		10
11		11
	11	11
	11	11
12		12
13		13
	13	13
	13	13
14		14
15		15
16		16
	16	16
	16	16
	16	16
17		17
18		18
19		19
20		20
21		21
	21	21
	21	21
	21	21
22		22
23		23
	23	23
	23	23
24		24
25		25
	25	25
	25	25

[apathetichell]

formula - new field - Tran #

if [detail item #]!=null() then [detail item #] else if [invoice item #]!=null() then [invoice item #] else  null() endif

[Apcvirgo1]

Hi @apathetichell 

Thanks for the response.

I'm receiving a Malformed error, for some reason it doesn't like the endif for some reason. I type the formula IN:

If [Detail Item Number]!=null()
then [Detail Item Number]
else if [Invoice Item Number]!=null()
then [Invoice Item Number]
else Null()
endif

[apathetichell]

elseif is one word.

[Qiu · Accepted solution]

@Apcvirgo1 
I think we should check all the possible combinatiosn just in case.

we can also use isnull() instead of =null(). 😁

[atcodedog05]

Hi @Apcvirgo1 

Here is my take

Hope this helps : )

[Qiu]

@atcodedog05 
Nice OOTB thinking 👍

[atcodedog05]

Hi @Qiu 

This specific trick/habit I got it from @MarqueeCrew 😁