I have a random two-column sheet that I need to list the values between in a single column. The output given the following two columns below should be shown below as well. Anyone with vba knowledge help?
I NEED THIS:
42
43
44
45
46
99
100
102
55
56
57
.
.
.
90
120
121
123
.
.
.
1111
66
67
68
.
.
.
99
Current file is comprised of this original values
I NEED THIS:
42
43
44
45
46
99
100
102
55
56
57
.
.
.
90
120
121
123
.
.
.
1111
66
67
68
.
.
.
99
Current file is comprised of this original values
42 | 46 |
99 | 102 |
55 | 90 |
120 | 1111 |
66 | 99 |