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 112 2 223 3 334 4 445 5 556 6 667 7 778 8 889 9 9910 10 1010 1 12 23 3 33 33 334 45 5 55 556 67 7 77 778 89 9 99 9910 1011 11 1111 111112 1213 13 1313 131314 1415 1516 16 1616 1616 161617 1718 1819 1920 2021 21 2121 2121 212122 2223 23 2323 232324 2425 25 2525 2525

Combine 2 columns into 1 without changing any data

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